How to loop through PostgreSQL Sequnces?

Databases
1

Hello all,

When removing all data from tables, I want to reset the squence counter back to 1.

This is the code that works:

ALTER SEQUENCE transactions_rowid_seq RESTART WITH 1;

I need to automate this so was wondering how to pull the sequences from Postgres automatically, then use them inside of a loop.

Any ideas??
Thanks,
Tim

2

Query information_schema.sequences.

3

Thank you Kem!
Tim

4

You could also use truncate and set the “RESTART IDENTITY” flag as described here:

3 Likes