Zeugswetter Andreas SB SD wrote: > > Imho it would be nice if the command would look exactly like a create > table. It is simply convenient to use cut and paste :-) And I haven't > seen a keyword yet, that would make it more descriptive, certainly not SET. > > ALTER TABLE blah ALTER [COLUMN] col [int4] [NOT NULL] [DEFAULT 32]; > ALTER TABLE blah ALTER [COLUMN] col [int8] [NULL] [DEFAULT 32]; > maybe even [DEFAULT NULL] to drop the default :-) >
I like this one. I would not make COLUMN optional though. -- Fernando Nasser Red Hat Canada Ltd. E-Mail: [EMAIL PROTECTED] 2323 Yonge Street, Suite #300 Toronto, Ontario M4P 2C9 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
