This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
version, or one of the supported versions listed above instead.
TRUNCATE -- empty a table
TRUNCATE [ TABLE ] name
The name (optionally schema-qualified) of the table to
- TRUNCATE TABLE
Message returned if the table is successfully
TRUNCATE quickly removes all rows
from a table. It has the same effect as an unqualified DELETE but since it does not actually scan the
table it is faster. This is most useful on large tables.
TRUNCATE cannot be executed inside a
transaction block (BEGIN/COMMIT pair), because there is no way to roll it
Truncate the table bigtable:
TRUNCATE TABLE bigtable;
There is no TRUNCATE in