Re: Referencing created tables fails with message that - Mailing list pgsql-general

From Doug McNaught
Subject Re: Referencing created tables fails with message that
Date
Msg-id 871xb14e45.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Referencing created tables fails with message that they do not exist!  (Tommy Svensson <tommy@tommysvensson.net>)
List pgsql-general
Tommy Svensson <tommy@tommysvensson.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

pgsql-general by date:

Previous
From: Troels Arvin
Date:
Subject: Re: Reading from Mysql & writting in PGsql
Next
From: Robby Russell
Date:
Subject: Re: Referencing created tables fails with message that