Re: newbie questions

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(at)yahoo(dot)com>
To: "Postgres Admin List" <pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org
>