Breaking News: Grepper is joining You.com. Read the official announcement!

truncate all tables in database postgresql

Emmanuel Mahuni answered on May 10, 2021 Popularity 10/10 Helpfulness 4/10

answer truncate all tables in database postgresql

truncate all tables in database postgresql

Comment

DO
$do$
BEGIN
   -- dangerous, test before you execute!
   RAISE NOTICE '%',  -- once confident, comment this line ...
   -- EXECUTE         -- ... and uncomment this one
   (SELECT 'TRUNCATE TABLE ' || string_agg(oid::regclass::text, ', ') || ' CASCADE'
    FROM   pg_class
    WHERE  relkind = 'r'  -- only tables
    AND    relnamespace = 'public'::regnamespace
   );
END
$do$;

Popularity 10/10 Helpfulness 4/10 Language actionscript

Source: stackoverflow.com

Tags: actionscript database postgresql truncate

Link to this answer
Share Copy Link