TRUNCATE

Attention

This page documents an earlier version. Go to the latest (v2.0)version.

Synopsis

TRUNCATE command clears all rows in a table.

truncate_stmt ::= TRUNCATE [ TABLE ] { [ ONLY ] name [ * ] } [, ... ]

Where

TRUNCATE acquires ACCESS EXCLUSIVE lock on the tables to be truncated. The ACCESS EXCLUSIVE locking option is not yet fully supported.
TRUNCATE is not supported for foreign tables.

postgres=# CREATE TABLE sample(k1 int, k2 int, v1 int, v2 text, PRIMARY KEY (k1, k2));

postgres=# INSERT INTO sample VALUES (1, 2.0, 3, 'a'), (2, 3.0, 4, 'b'), (3, 4.0, 5, 'c');

postgres=# SELECT * FROM sample ORDER BY k1;

 k1 | k2 | v1 | v2
----+----+----+----
  1 |  2 |  3 | a
  2 |  3 |  4 | b
  3 |  4 |  5 | c
(3 rows)

postgres=# TRUNCATE sample;

postgres=# SELECT * FROM sample;

 k1 | k2 | v1 | v2
----+----+----+----
(0 rows)