Re: how to rename an unnamed uniqueness constraint?

From: Oliver Kullmann <O(dot)Kullmann(at)swansea(dot)ac(dot)uk>
To: Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: how to rename an unnamed uniqueness constraint?
Date: 2005-08-17 16:36:13
Message-ID: 20050817163613.GB14100@cs-wsok.swansea.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Aug 17, 2005 at 06:52:08AM +1200, Andrej Ricnik-Bay wrote:
> In psql a
> \d+ <tablename>
> will give you the name of the actual constraint.
>
>
> Cheers,
> Tink
>

thanks!

BTW: why "d+ <tablename>" and not "d <tablename>" ?!
In the examples I tried the results where the same
(only d+ seems to add some spaces).

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Kullmann 2005-08-17 16:40:28 Re: how to rename an unnamed uniqueness constraint?
Previous Message Bruno Wolff III 2005-08-17 04:48:50 Re: Modifiable sequence column?