mirror of
https://github.com/jbranchaud/til
synced 2026-01-02 22:58:01 +00:00
22 lines
567 B
Markdown
22 lines
567 B
Markdown
# Truncate All Rows
|
|
|
|
Given a postgres database, if you want to delete all rows in a table, you
|
|
can use the `DELETE` query without any conditions.
|
|
|
|
```sql
|
|
> delete from pokemons;
|
|
DELETE 151
|
|
```
|
|
|
|
Though `DELETE` can do the job, if you really are deleting all rows to clear
|
|
out a table, you are better off using `TRUNCATE`. A `TRUNCATE` query will be
|
|
faster than a `DELETE` query because it will just delete the rows without
|
|
scanning them as it goes.
|
|
|
|
```sql
|
|
> truncate pokemons;
|
|
TRUNCATE TABLE
|
|
```
|
|
|
|
[source](http://www.postgresql.org/docs/8.2/static/sql-truncate.html)
|