How to Truncate a Table in PostgreSQL

Last updated July 24, 2026 · By the SaturnSQL team

TRUNCATE removes all rows instantly and, unlike MySQL, is transactional in Postgres: you can ROLLBACK it. Use RESTART IDENTITY to reset sequences and CASCADE for tables referenced by foreign keys.

TRUNCATE TABLE session_logs;

TRUNCATE TABLE orders RESTART IDENTITY CASCADE;