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 [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]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 > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
