Is this the only way to add attributes to an existing table, and add
unique and a default(for example) to existing attributes?
Just wondered if there are alternatives. I didn't really see this in
the docs or mailing lists.
Thanks for any input.
CREATE TABLE table (
CREATE TABLE newtable (
attrib1 int UNIQUE,
attrib2 int DEFAULT 1,
INSERT INTO newtable (attrib1, attrib2)
SELECT attrib1, attrib2 FROM table;
DROP TABLE table;
ALTER TABLE newtable RENAME TO table;
pgsql-admin by date
|Next:||From: Jason||Date: 2001-08-03 11:50:01|
|Subject: A replication like process|
|Previous:||From: Tom Lane||Date: 2001-08-03 00:33:58|
|Subject: Re: Memory exhausted errors |