From: | <kynn(at)panix(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Cannot insert a duplicate key into unique index |
Date: | 2004-02-19 14:43:17 |
Message-ID: | 200402191443.i1JEhHt18578@panix3.panix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
X-Original-To: kynn(at)panix(dot)com
Date: Thu, 19 Feb 2004 15:12:09 +0100
From: daq <daq(at)ugyvitelszolgaltato(dot)hu>
kpc> Thank you all for the help. I'm almost there.
kpc> How can I list all the sequences in the database, with their
kpc> attributes (such as last_value)? (I'm having a hard time guessing
kpc> 'seq-name'; the 'A_id_seq' formula did not work.)
kpc> For that matter (going beyond my original question) does PostgreSQL
kpc> have anything like a comprehensive "catalog" function that will list
kpc> all the tables, their fields, etc. defined in the database?
You can list all the sequences:
select relname from pg_class where relkind='S';
and list all their atributes:
select * from sequence_name;
See "System Catalogs" in the documentation!
Way cool. Thanks.
BTW, I was wrong when I said that the 'A_id_seq' formula did not work
(it turns out that it failed due to a typo of mine).
kj
From | Date | Subject | |
---|---|---|---|
Next Message | joseph speigle | 2004-02-19 15:10:21 | Re: Cannot insert a duplicate key into unique index |
Previous Message | Terry Lee Tucker | 2004-02-19 14:33:02 | Re: Cannot insert a duplicate key into unique index |