Re: Can't query the sequence table of a serial primary key.

"Fred Parkinson" <FredP@abag.ca.gov> wrote:

> When I do \d I see the table and the sequencer under 'List of
> relations'.  But when I run select * from mytable_id_seq;
> postgresql responds with: relation 'mytable_id_seq' does not
> exist.

It works for me.  Can you provide a small self-contained test case
which demonstrates the problem?

Hopefully you are aware of these functions, which might be easier:

http://www.postgresql.org/docs/8.4/interactive/functions-sequence.html

-Kevin