This email demonstrates how important GUIs are for database users. It seems
like users are judging PostgreSQL on the ability to create, view and modify
PostgreSQL objects.
Dave Page wrote a very nice GUI called pgAdmin II
(http://padmin.postgresql.org).
It gives access to all PostgreSQL features. It is a must-have, especially if
you want to use PostgreSQL 7.2 and its CREATE OR REPLACE FUNCTION which are
supported.
I would also like to take the opportunity to point out (again) how important
are on the to-do list : CREATE OR REPLACE VIEW, CREATE OR REPLACE TRIGGER. In
addition, we would like to have a better CREATE TABLE AS with a choice of
preserving/dropping linked objects (primary key, triggers, rules) and
hopefully an ALTER TABLE ALTER COLUMN clause.
Why not concentrate on these very simple features before going further? This
would bring a bunch of people from beginner tools (MySQL) as well as advanced
ones (Oracle, MS SQL Server) to PostgreSQL.
Best regards,
Jean-Michel POURE