Thursday, May 10, 2007

Alter table - Modify table

Postgresql doesnot provide to modify tables, like Oralcle

To modify table first you have to drop column and then ADD column again..

test2=# ALTER TABLE tbl1 DROP column col1;

test2=# ALTER TABLE tbl1 ADD column col_new VARCHAR(10);