How to get back the current count of a auto incrementing number.

From: sid tow <siddy_tow(at)yahoo(dot)com>
To: psql mailing list <pgsql-general(at)postgresql(dot)org>
Subject: How to get back the current count of a auto incrementing number.
Date: 2005-01-28 11:36:40
Message-ID: 20050128113640.97770.qmail@web42103.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Regards.


__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2005-01-28 11:56:58 Re: How to get back the current count of a auto
Previous Message Miguel Angel Tribaldos Hervas 2005-01-28 10:26:31 Re: Import SVG file