Hello, 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 column. 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. Nicolas Ribot SCOT [EMAIL PROTECTED]
