Skip to content →

PostgreSQL Sequences

Today I was trying to figure out the name of a sequence in the db, so I could add it to my hibernate mapping.  I usually use pgAdmin, but that wasn’t an option today.  After some searching, I eventually figured it out, but it took me awhile…

Get a list of all Sequences in a schema:

select sequence_name from information_schema.sequences where sequence_schema='public'

Get a list of all tables:

select table_name from information_schema.tables where table_schema='public'

Get the next sequence value for sequence: foo_seq

SELECT setval('foo_seq', 42);

Update the sequence to 42 for sequence: foo_seq

select nextval('foo_seq');

Note if you are looking for more info on sequences check here: Sequence-Manipulation Functions

Published in Code