TRUNCATE [ TABLE ] [ ONLY ] name [ * ] [, ... ] [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ]
Remove all data from one table
TRUNCATE TABLE table_name;
Besides removing data, you may want to reset the values in the identity column by using the RESTART IDENTITY
option like this:
TRUNCATE TABLE table_name RESTART IDENTITY;
Remove all data from a table that has foreign key references
TRUNCATE TABLE table_name CASCADE;
References
https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-truncate-table/
https://www.postgresql.org/docs/current/sql-truncate.html