Re: Probably a stupid question
От | Chad Thompson |
---|---|
Тема | Re: Probably a stupid question |
Дата | |
Msg-id | 011701c33ce8$f801e9a0$32021aac@chad обсуждение исходный текст |
Ответ на | Best Practice?? (phil campaigne <pcampaigne@charter.net>) |
Список | pgsql-novice |
I believe your problem is simply with the case of the table name. You might want to try \d mirrorhosts. If the table was created "MirrorHosts" (which it looks like it was) postgresql will store that name and you will be required to reference it like that. I believe there is something in the docs about case sensitivity, but I cant seem to find it now. HTH Chad ----- Original Message ----- From: "Giorgio Ponza" <g.ponza@opla.it> To: <pgsql-novice@postgresql.org> Sent: Friday, June 27, 2003 1:37 AM Subject: [NOVICE] Probably a stupid question > Hi all, and tx for all the help you give to the community > I have a question, really stupid, but i'd like to understand the postgres > behavior. > I installed dbmirror, and there is a file script creating a table, something > like this: > CREATE TABLE "MirrorHosts" ..... etc etc > > Ok, no prob with the syntax (3 years i use postgreSQL), but when i use psql > i have this problems: > 1) the command \d MirrorHosts doesn't work (table MirrorHost not found), > i have to use \d "MirrorHosts" > 2) when i do SELECT * FROM MirrorHosts; (the same prob) > i have to use "MirrorHosts" > > I'd like to know if there is a way to bypass this problem. > Tx in advance and ..... PostgreSQL is really GREAT! > > Giorgio Ponza > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match >
В списке pgsql-novice по дате отправления: