Example: Emptying a table v16
This example removes the data from the sales
table.
Create the sales
table:
Populate the sales
table:
Query the sales
table to show that the partitions have data:
Delete the contents of the sales
table:
Query the sales
table to show that the data was removed but the structure is intact:
For more information about the TRUNCATE TABLE
command, see the PostgreSQL documentation.