alter table <tablename> drop constraint ID unique;
alter table <tablename> drop constraint ID not null;
alter table <tablename> add constraint ID references table2 ;
Here is where you can find the documentation for this:
The "alter":
http://www.postgresql.org/idocs/index.php?sql-altertable.html
The constraints:
http://www.postgresql.org/idocs/index.php?sql-createtable.html
regards,
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of MG
> Sent: Thursday, May 02, 2002 3:28 PM
> To: PostgreSQL List
> Subject: [ADMIN] ALTER TABLE for field modify...
>
>
>
> Hi!
>
> How can I modify a field of table with ALTER TABLE? I want to modify the
> constraint. The TABLE is now:
> "ID" int8 NOT NULL, UNIQUE
>
> But I want this:
> "ID" int8 REFERENCE "table2"
>
>
> THanx!
> Bye!
> -----------------
> Linux RedHat 7.1
> -----------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>