Postgres Pro
Downloads
Home   >   mailing lists

Re: how to rename an unnamed uniqueness constraint? - Mailing list pgsql-novice

From Oliver Kullmann
Subject Re: how to rename an unnamed uniqueness constraint?
Date
Msg-id 20050817163613.GB14100@cs-wsok.swansea.ac.uk
Whole thread Raw
In response to how to rename an unnamed uniqueness constraint?  (Oliver Kullmann <O.Kullmann@swansea.ac.uk>)
List pgsql-novice
Tree view 
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).

pgsql-novice by date:

Previous
From: Oliver Kullmann
Date:
Subject: Re: how to rename an unnamed uniqueness constraint?
Next
From:
Date:
Subject: My First Stored Procedure