Joost Kraaijeveld <J.Kraaijeveld <at> Askesis.nl> writes: > Does this work (replace the names according to your schema)? > > BEGIN; > ALTER TABLE table_name ADD COLUMN new_column varchar(64)?; > UPDATE table_name SET new_column = column; > ALTER TABLE customer RENAME column TO old_column; > ALTER TABLE customer RENAME new_column TO columns; > COMMIT;
In the end, I did this plu I dropped the old column, but what's the point of having a tool like pgAdmin if common place everyday activities like this can't be done? ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly