TRUNCATE¶

TRUNCATE removes all rows from a table.

It is functionally identical to running a DELETE statement without a WHERE clause.

Permissions¶

The role must have the DELETE permission at the table level.

Syntax¶

truncate_table_statement ::=
    TRUNCATE [ TABLE ] [schema_name.]table_name
    ;

table_name ::= identifier

schema_name ::= identifier

Parameters¶

Parameter	Description
`schema_name`	The name of the schema for the table.
`table_name`	The name of the table to truncate.

Examples¶

Truncating a table¶

farm=> SELECT * FROM cool_animals;
1,Dog                 ,7
2,Possum              ,3
3,Cat                 ,5
4,Elephant            ,6500
5,Rhinoceros          ,2100
6,\N,\N

6 rows

farm=> TRUNCATE TABLE cool_animals;
executed

farm=> SELECT * FROM cool_animals;

0 rows