psql-sequences.md

psql sequences

show all sequences with schema name info

select schemaname,sequencename from pg_sequences;

alter sequence

alter sequence "myschema"."sequencename" RESTART WITH newval;