> For the complete documentation index, see [llms.txt](https://ploegert.gitbook.io/til/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/queries/truncate-all-rows.md).

# 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)