DROP TABLE table_name
The DROP TABLE command deletes an entire table and the data stored in the table. When you delete a table, all partitions and subpartitions of the table are also deleted.
To use the DROP TABLE command, you must be the owner of the partitioning root, a member of a group that owns the table, the schema owner, or a database superuser.
|table_name||The name (optionally schema-qualified) of the partitioned table.|
DROP TABLE sales;
acctg=# drop table sales; DROP TABLE acctg=#
For more information about the DROP TABLE command, see the PostgreSQL core documentation.