Re: newbie questions - Mailing list pgsql-admin

From Mauricio
Subject Re: newbie questions
Date
Msg-id 005f01c2744d$f44e6f40$3501a8c0@Azenha
Whole thread Raw
In response to newbie questions  (Xue-Feng Yang <just4look@yahoo.com>)
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
> 

pgsql-admin by date:

Previous
From: Xue-Feng Yang
Date:
Subject: newbie questions
Next
From: Tom Lane
Date:
Subject: Re: Trouble dumping "backing up" in 7.1.3