On Aug 25, 2009, at 3:25 PM, Carol Walter wrote:
This may be a silly question but I don't see any place where the
documentation explicitly addresses whether or not you can designate
a particular column as a primary key after the table is created. I
used the "create table as " syntax to create a table with the same
columns as an original table, but I want to rename id column, make
it a serial, and designate it as a primary key. Is it possible to
do this? I've tried a number of things to do this and none of them
have worked.
See this document: http://www.postgresql.org/docs/8.3/static/sql-altertable.html
for example: ALTER TABLE distributors ADD PRIMARY KEY (dist_id);
Also checkout pgAdmin III....
Ries
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
regards, Ries van Twisk
-------------------------------------------------------------------------------------------------
tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS
WebORB PostgreSQL DB-Architect
email: r...@vantwisk.nl web: http://www.rvantwisk.nl/
skype: callto://r.vantwisk
Phone: +1-810-476-4196 Cell: +593 9901 7694 SIP:
+1-747-690-5133
