Re: Is there a gui front end for this wonderful db program

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема Re: Is there a gui front end for this wonderful db program
Дата
Msg-id 20060725012536.50124.qmail@web31805.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: Is there a gui front end for this wonderful db program  (Fred Frazelle <frazelle09@yahoo.com>)
Список pgsql-novice
> And i guess i´m not looking for a driver per se, but a frontend which
> would give us the funcionality of Access.

I understand a what you are looking for a little bit better.  That being the case, I think I
should dispel a notion that I think you have regarding postgresql.  In access, you can create two
tables.  You can also create a select query that will join both tables.  The following things can
be achieved in the same way with postgresql as well.

However the similarities slightly diverge with your next requirement.  In postgresql, you can not
insert a record in to a query view (where the linked tables in the select statement are cascaded
related insert statements) as ms-access allows you to do.

This functionality can be achieved by creating a view (i.e. a query stored on the server) and then
by adding insert, update, and deleted rules to that view;  all changes to the views records will
be directed to the appropriate tables that the view as created from.

http://www.postgresql.org/docs/8.1/interactive/tutorial-views.html
http://www.postgresql.org/docs/8.1/interactive/rules-update.html

Using this functionality, you could bind a form (i.e. like ms-access/odbc or OOO) to this newly
created view to get the same functionality you would get from an ms-access select query.

of course, an alternative to creating a view with rules is to use one of the many client interface
APIs. With these, you could simulate the same functionality using code. This solution requires a
steeper learning curve however.

Regards,

Richard Broersma Jr.


В списке pgsql-novice по дате отправления:

Предыдущее
От: Fred Frazelle
Дата:
Сообщение: Re: Is there a gui front end for this wonderful db program
Следующее
От: Tom
Дата:
Сообщение: Re: Is there a gui front end for this wonderful db program which works like MSAccess?