I was wondering if it is possible to get the name of sequences created
for a table by an SQL query ?
Ex: I have a parcel table, with a sequence created on it for the PK
A java program, that doesn't know this sequence name needs to retrieve
the unique ID of the object recently inserted into the parcel table.
I would like to do something like
select currval( (select seqname from pg_xxx where table_name='parcel')
I looked at the pg_class system table and see both my table and its
sequence, but do not find a way to join them in a query.
Thanx for any help.
pgadmin-hackers by date
|Next:||From: firstname.lastname@example.org||Date: 2002-03-15 10:15:17|
|Subject: upgrade wizard proxy connection|
|Previous:||From: rose.coil||Date: 2002-03-15 06:13:39|