On Jan 28, 2005, at 6:36 AM, sid tow wrote:
hi
How to get the current value of a auto incrementing number generated using CREATE SEQUENCE seqname START 1
Is there any way and if yes what is it. Can we run a select query and may be a inbuilt function which will return the current value of that number?
Look at:
http://www.postgresql.org/docs/8.0/interactive/functions-sequence.html
Sean
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend