Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

MOD: Reset/Recalculate Sequence



I am often transferring data from one system to another , and I would really
like a command ( even single sequence level)
To get the highest value in a sequence field and set the sequence to it..


E.G Right click on the sequence and select 'Reset to Highest in Table'  I
grabs the Highest value from the table and sets the current value to that
+1.

Cheers

Traci




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group