Skip to content

Instantly share code, notes, and snippets.

@vskrachkov

vskrachkov/select_all_sequences.sql

Created April 4, 2017 10:50
Show Gist options
  • Save vskrachkov/67988a0b621535bb2a96d7500b624af7 to your computer and use it in GitHub Desktop.
Save vskrachkov/67988a0b621535bb2a96d7500b624af7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select_all_sequences.sql
SELECT 'SELECT setval(''main_' || c.relname || ''', nextval(''' || n.nspname || '.' || c.relname || ''') + 20);' FROM pg_class c
JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind = 'S' and n.nspname = 'main';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment