Exporting sequences in PostgreSQL

Question

I want to export ONLY the sequences created in a Database created in PostgreSQL. There is any option to do that?

Thank you!

Answer 1

You could write a query to generate a script that will create your existing sequence objects by querying this information schema view.

select *
from information_schema.sequences;

Something like this.

SELECT 'CREATE SEQUENCE ' || sequence_name || ' START ' ||  start_value || ';'
from information_schema.sequences;