Re: How to find the definition of a sequence ?
select * from seq_id_top;
Should give you what you want
Hi !
I have a database created by a friend of mine. In it there is a sequence
called seq_id_top. How can I find out its definition (start, increment,
max value) ?I use version 7.3.2
Many thanks in advance,
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Import Notes
Reply to msg id not found: 20030611174717.12991ccd.liviu@voxline.ro
select * from seq_id_top
Travis
-----Original Message-----
From: Liviu BURCUSEL [mailto:liviu@voxline.ro]
Sent: Wednesday, June 11, 2003 9:47 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to find the definition of a sequence ?
Hi !
I have a database created by a friend of mine. In it there is a sequence
called seq_id_top. How can I find out its definition (start, increment,
max value) ?
I use version 7.3.2
Many thanks in advance,
--
Liviu BURCUSEL
Registered Linux User #221627
5:44pm up 8:13, 6 users, load average: 0.08, 0.09, 0.13
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
Import Notes
Resolved by subject fallback