postgresqlHow do I truncate a table in PostgreSQL?
To truncate a table in PostgreSQL, you can use the TRUNCATE command. This command removes all rows from the table quickly and efficiently.
Example code
TRUNCATE TABLE my_table;The code above will remove all rows from the table my_table. No output will be returned.
The TRUNCATE command has the following parts:
TRUNCATE- the command to truncate a tableTABLE- specifies that you are truncating a tablemy_table- the name of the table you are truncating
For more information, please see the PostgreSQL documentation.
More of Postgresql
- How do I use PostgreSQL's XMLTABLE to parse XML data?
- How do I convert a string to lowercase in PostgreSQL?
- How can I use PostgreSQL and ZFS snapshots together?
- How can I troubleshoot zero damaged pages in PostgreSQL?
- How can I use PostgreSQL's "zero if null" feature?
- How can I integrate PostgreSQL with Yii2?
- How can I use PostgreSQL with YAML?
- How can I retrieve data from PostgreSQL for yesterday's date?
- How can I extract the year from a PostgreSQL timestamp?
- How do I use PostgreSQL's XMIN and XMAX features?
See more codes...