Re: Referencing created tables fails with message that

Tommy Svensson <tommy(at)tommysvensson(dot)net> writes:

> I have just installed Postgresql and tried it for the first time.
>
> One very serious problem I ran into was when actually trying to use
> created tables.
> Creating a simple table without any foreign keys works OK, but after
> creating the
> table it is not possible to do a select on it! I tried the following
> variants:
>
> 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!".

I bet it's a case problem. Please give the actual table name and the
exact SQL you are using to create and access it.

-Doug