Chuming Chen wrote:
Peter Eisentraut wrote:
Chuming Chen wrote:
How can I change the column definition of an existing table, ie. from
varchar(30) to varchar(50)? Is there any way to add a new column to
an existing table?
The ALTER TABLE command can do all that. You need version 8.0 or
later for some functionality though.
Is there another way to do it in 7.* ?
http://www.postgresql.org/docs/faqs.FAQ.html#4.3
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
