By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,969 Members | 1,579 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,969 IT Pros & Developers. It's quick & easy.

Sequences cache change

P: 1
Hello, I have to change cache for all sequences in schema and database.I can not change one by one.My question, is there some script or query which can change cache size for all sequences ??Please help me.

Best regards
3 Weeks Ago #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,380
Can you explain why you are attempting this?
Sequences are normally one-direction counters alot like the autonumber field in and Access database or the Auto_Increment in MySQL databases

There is a way to set the sequence to a given value but I don't think it's usually advisable

With that said, you might find the following helpful:
https://postgrespro.com/docs/postgre...-altersequence
2 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.