Skip to content

Instantly share code, notes, and snippets.

@heijmerikx
Forked from tbarbugli/reset.sql
Created February 12, 2022 08:36
Show Gist options
  • Save heijmerikx/b3e7958be03bd7f34ee4bd8f46ed040c to your computer and use it in GitHub Desktop.
Save heijmerikx/b3e7958be03bd7f34ee4bd8f46ed040c to your computer and use it in GitHub Desktop.
reset all sequences on a postgres db
SELECT 'SELECT SETVAL(' ||quote_literal(S.relname)|| ', MAX(' ||quote_ident(C.attname)|| ') ) FROM ' ||quote_ident(T.relname)|| ';'
FROM pg_class AS S, pg_depend AS D, pg_class AS T, pg_attribute AS C
WHERE S.relkind = 'S'
AND S.oid = D.objid
AND D.refobjid = T.oid
AND D.refobjid = C.attrelid
AND D.refobjsubid = C.attnum
ORDER BY S.relname;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment