Skip to content

Instantly share code, notes, and snippets.

@onhernandes

onhernandes/pg_sequences.sql

Created October 13, 2022 18:16
Show Gist options
  • Save onhernandes/d8d3f40d2e87a3438381bcb97fd6e45b to your computer and use it in GitHub Desktop.
Save onhernandes/d8d3f40d2e87a3438381bcb97fd6e45b to your computer and use it in GitHub Desktop.
Download ZIP
Nice sequence queries for PG
Raw
pg_sequences.sql
-- set as bigint
ALTER SEQUENCE transaction_id_seq AS BIGINT;
-- select sequences
SELECT * FROM information_schema.sequences ORDER BY sequence_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment