TRUNCATE ​

Delete all of the rows from one or more tables.

TRUNCATE [ TABLE ] name [, ... ]
   [ CASCADE | RESTRICT ]

This is a faster operation than an unqualified DELETE operation. When data is deleted or truncated it continues to exist in the system for a period of time until it can be efficiently removed and data can be reorganized. These optimizations are fully automatic and require no administration or manual interaction.

Use the CASCADE option to automatically truncate tables that have foreign-key references to the named tables.

Note: You cannot truncate tables in hot-standby databases.

Rollback is supported for TRUNCATE operations.

For example, truncate three tables:

premdb=# truncate table hometeam, awayteam, team;
TRUNCATE TABLE