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);