Relation "xxxxx" does not exist - more info

Поиск
Список
Период
Сортировка
От Valter
Тема Relation "xxxxx" does not exist - more info
Дата
Msg-id 003701c40c4b$5942b140$01ff020a@intersic.com.br
обсуждение исходный текст
Ответ на Relation "xxxxx" does not exist  ("Valter" <pgsql@intersic.com.br>)
Ответы Re: Relation "xxxxx" does not exist - more info
Список pgsql-general
Дерево обсуждения
What I didn't perceived before is DTS and pgAdmin create tables using quoted names like:
 
CREATE TABLE "XYZ" ....
 
while I create tables using non-quoted names like CREATE TABLE ABC.
 
It happens that altough invisible to \dt am I unable to use these tables either in psql or DTS.
 
In sum, DTS creates the table but doesn't transfer data.
 
Is quoted names a matter of postgre config?
 
Thanks,
 
Valter
----- Original Message -----
From: Valter
Sent: Wednesday, March 17, 2004 2:52 PM
Subject: [GENERAL] Relation "xxxxx" does not exist

When I create tables thru DTS (mssqlserver) or pgAdmin, I get the following message when I try select/insert row from/into this tables:

Relation "table-name" does not exist
 
Command \dt lists all the tables, but \dt PATTERN doesn't.
 
Could it be charset/sort order or something like that?
 
All client softwares but pgsql are running on windows2k
 
Valter

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