PostgreSQL – Drop Column

Syntax to drop a column in postgres database:

ALTER TABLE tablename DROP COLUMN columnname;

See also  PostgreSQL - Get Table Size