Re: Referencing created tables fails with message that

Поиск
Список
Период
Сортировка
От Chris Smith
Тема Re: Referencing created tables fails with message that
Дата
Msg-id 42229341.6080404@interspire.com
обсуждение исходный текст
Ответ на Referencing created tables fails with message that they do not exist!  (Tommy Svensson <tommy@tommysvensson.net>)
Список pgsql-general
Try putting quotes around the table name:

select * from "Table";

?

Do you see it in the table list?

\dt


Tommy Svensson wrote:
> 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!".
>
> Creating a new table with a foreign key referencing the first table is
> also impossible due to exactly the same error message!
>
> This behaviour is the same using  DBVisualizer/jdbc or psql.
>
> So the question is how do you actually reference the tables you have
> created so that postgres will find them ?
> The tables do actually get created. I can se them in DBVisualizer.
>
> I'm using version 7.4.5 on Linux Mandrake 10.1.
>
> Best Regards,
> Tommy Svensson
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>

--
Regards,

Chris Smith

Suite 30, 45-51 Huntley St, Alexandria, NSW 2015 Australia

Ph: +61 2 9517 2505
Fx: +61 2 9517 1915

email: info@interspire.com
web: www.interspire.com

В списке pgsql-general по дате отправления:

Предыдущее
От: "Guy Rouillier"
Дата:
Сообщение: Re: exporting table for load into oracle
Следующее
От: Tino Wildenhain
Дата:
Сообщение: Re: postgresql 8.0 advantages