RTFM. www.postgresql.org -> your favorite mirror -> interactive documentation (http://www.postgresql.org/idocs/) -> SQL Commands (http://www.postgresql.org/idocs/index.php?sql-commands.html) -> ALTER TABLE (http://www.postgresql.org/idocs/index.php?sql-altertable.html) It wasn't that hard. :-) http://www.postgresql.org/idocs/index.php?sql-altertable.html hugs & kisses, Mauricio ----- Original Message ----- From: "Xue-Feng Yang" <[EMAIL PROTECTED]> To: "Postgres Admin List" <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 10:13 AM Subject: [ADMIN] newbie questions > Are there the following SQL commands in psotgreSQL? > > ALTER TABLE CATALOGITEM_LNK ADD > CONSTRAINT PK_CATALOGITEM_LNK PRIMARY KEY(catalogid, > itemid); > > ALTER TABLE CATALOGITEM_LNK ADD > CONSTRAINT FK_CATALOGITEM_LNK_CATALOG FOREIGN KEY > (catalogid) REFERENCES CATALOG(id); > > > ______________________________________________________________________ > Post your free ad now! http://personals.yahoo.ca > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] >
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
