Re: Referencing created tables fails with message that they do not exist!

On Sun, Feb 27, 2005 at 06:50:50PM -0500, Tommy Svensson wrote:

> SELECT * FROM <table>;
> SELECT * FROM public.<table>;
> SELECT * FROM <schema>.public.<table>;
>
> All result in the message "The relation <table> does not exist!" or "The
> relation public.<table> does not exist!".

Could you copy and paste the *exact* commands and error messages
and send them to the list? That might help us see what's going on.

> The tables do actually get created. I can se them in DBVisualizer.

If you run psql, what does \d show? (Again, please copy and paste
the exact output.) Is it possible that you created the tables in
mixed case and didn't quote their names when you tried to query
them? If so, then you might want to read "Identifiers and Key
Words" in the "SQL Syntax" chapter of the documentation.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/