On fre, 2010-04-09 at 18:01 -0400, Josh Kupershmidt wrote: > I often come across tables with either a unique index or a unique > constraint on them, and psql isn't helpful at showing the difference > between the two. Normally, I don't care which is which, except for > when I have to manually drop and recreate the index or constraint to > speed up a bulk load. Yes, I have also been annoyed by that. Perhaps you could work out a proposed change and send it to the hackers list. You don't necessarily need to code it up, but make some mock-ups about how things would look in different situations. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general