Re: psql's \d display of unique index vs. constraint

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psql's \d display of unique index vs. constraint
Date: 2010-04-11 16:48:34
Message-ID: 1271004514.20272.1.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ckarthic 2010-04-11 20:44:02 Displaying the output of a query over a web interface.
Previous Message Jeffrey Ottery 2010-04-11 06:45:25 Re: Unable to uninstall postgres from Add/Remove programs

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-04-11 18:47:36 Re: GSoC - proposal - Materialized Views in PostgreSQL
Previous Message Heikki Linnakangas 2010-04-11 14:26:03 Re: GSoC - proposal - Materialized Views in PostgreSQL