Re: Cannot insert a duplicate key into unique index

>
> 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.)
>
> You can list all the sequences:
>
> select relname from pg_class where relkind='S';
>
> and list all their atributes:
>
> select * from sequence_name;
>

select last_value from something_seq

And I got the sequence name from \ds at the psql prompt! but that's only for the current database.

joe
--
speigle
www.sirfsup.com