In order to drop a column to a table in PostgreSQL, we type the following:
ALTER TABLE myTable
DROP COLUMN columnName;
If you want to drop a table column and its dependents, we type the following:
ALTER TABLE myTable
DROP COLUMN columnName CASCADE;
If you want to drop a table column if it exists, we type the following:
ALTER TABLE myTable
DROP COLUMN IF EXISTS columnName;
If you want to drop multiple columns in a table, we type the following:
ALTER TABLE myTable
DROP COLUMN columnName1,
DROP COLUMN columnName2;