Created
June 15, 2020 12:38
-
-
Save muhammadkholidb/bad055cbebb79f10c41ada49fa5053c8 to your computer and use it in GitHub Desktop.
Fixing PostgreSQL Sequence
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT 'SELECT SETVAL(' || | |
quote_literal(quote_ident(PGT.schemaname) || '.' || quote_ident(S.relname)) || | |
', COALESCE(MAX(' ||quote_ident(C.attname)|| '), 1) ) FROM ' || | |
quote_ident(PGT.schemaname)|| '.'||quote_ident(T.relname)|| ';' | |
FROM pg_class AS S, | |
pg_depend AS D, | |
pg_class AS T, | |
pg_attribute AS C, | |
pg_tables AS PGT | |
WHERE S.relkind = 'S' | |
AND S.oid = D.objid | |
AND D.refobjid = T.oid | |
AND D.refobjid = C.attrelid | |
AND D.refobjsubid = C.attnum | |
AND T.relname = PGT.tablename | |
ORDER BY S.relname; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
That query will generate queries to update sequences from tables in the database.
Read more at https://wiki.postgresql.org/wiki/Fixing_Sequences