Skip to content

Instantly share code, notes, and snippets.

@horaciod

horaciod/seq-max.sql

Created June 24, 2023 22:10
Show Gist options
  • Save horaciod/4b221b61cd437dca8589ed2e33cdf986 to your computer and use it in GitHub Desktop.
Save horaciod/4b221b61cd437dca8589ed2e33cdf986 to your computer and use it in GitHub Desktop.
Download ZIP
Sql para generar todas las sqls necesarias para verificar los max y las sequencias de un postgresql 13
Raw
seq-max.sql
-- sql para generar todas las sqls necesarias para verificar los max y las sequencias de un postgresql 13
select
'select '''|| sequencename || ''', max(id) , '|| last_value::text || ' as sec from ' || replace( sequencename , '_id_seq',' ; ')
from pg_sequences ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment