January 2002
Intermediate to advanced
640 pages
16h 39m
English
Content preview from Practical PostgreSQLBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Truncate
Empties the contents of a table.
Synopsis
TRUNCATE [ TABLE ] nameParameters
nameThe name of the table you wish to truncate. To truncate a table means to remove all rows from the table.
Results
TRUNCATEThe message returned if the specified table is successfully truncated.
ERROR: Relation 'name' does not existThe error returned if the specified table
namedoes not exist in the connected database.
Description
Use this command to remove all rows of a specified table. It does not scan through the
table before removing data, making it rather helpful when emptying large tables of data. In
essence, it is a quicker form of the DELETE command.
Example
This example empties all of the rows in the temp_emp table:
booktown=# TRUNCATE TABLE temp_emp;
TRUNCATE