Обсуждение: 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
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.
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? http://archives.postgresql.org
Liviu BURCUSEL <liviu@voxline.ro> writes: > 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) ? SELECT * FROM seq_id_top; regards, tom lane
SELECT * FROM seq_id_top Liviu BURCUSEL schrieb: > 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,