Alter table - Modify table in PostgreSQL
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);
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);