To delete a column from table , I am following the method as per postgresl documents.
1) creating emptable with same structure and moving all records.
2) creating another table with out column which you have remove.
3) Creating all constraints.
4) moving all data from temp table to new table and removing temp table.
Is there any way to delete a column, other than above method
Regards,
Sreedhar