truncate all tables in database postgres code example

Example 1: truncate table postgres

TRUNCATE TABLE table_name;

Example 2: truncate table postgres

truncate my_table restart identity