how to delete table field postgresql code example
Example 1: psql drop field
ALTER TABLE table_name DROP COLUMN column_name;
Example 2: psql delete table
DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
ALTER TABLE table_name DROP COLUMN column_name;
DROP TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]