Re: newbie questions - Mailing list pgsql-admin

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" <just4look@yahoo.com>
To: "Postgres Admin List" <pgsql-admin@postgresql.org>
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 majordomo@postgresql.org
>