Re: Referencing created tables fails with message that

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Referencing created tables fails with message that
Дата
Msg-id 871xb14e45.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на Referencing created tables fails with message that they do not exist!  (Tommy Svensson <tommy@tommysvensson.net>)
Список 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 по дате отправления:

Предыдущее
От: Troels Arvin
Дата:
Сообщение: Re: Reading from Mysql & writting in PGsql
Следующее
От: Robby Russell
Дата:
Сообщение: Re: Referencing created tables fails with message that