select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 7.0
Historical version. PostgreSQL 7.0 reached end of support in May 2005. See the current manual for supported releases.

TRUNCATE

Name

TRUNCATE — Empty a table
TRUNCATE [ TABLE ] name
  

Inputs

name

The name of the table to be truncated.

Outputs

TRUNCATE

Message returned if the table is successfully truncated.

Description

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 effective on large tables.

Usage

Truncate the table bigtable:

TRUNCATE TABLE bigtable;
   

Compatibility

SQL92

There is no TRUNCATE in SQL92.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.