"Fred Parkinson" <FredP(at)abag(dot)ca(dot)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