How to run queries without double quotes on tables and columns

Поиск
Список
Период
Сортировка
От Susan M Farley
Тема How to run queries without double quotes on tables and columns
Дата
Msg-id f606829d7f627.4ad0fd13@gmu.edu
обсуждение исходный текст
Ответы Re: How to run queries without double quotes on tables and columns  (Thom Brown <thombrown@gmail.com>)
Re: How to run queries without double quotes on tables and columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Sorry, I'm really new to PostgreSQL and am used to Oracle. In function and in regular queries, I usually have to have
doublequotes (") around the names of columns and table names. Otherwise, I get an error that the schema, table, or
columndoesn't exist. I don't always have to though. Sometimes the function works just fine without them even though I
amworking with the same table and schema. What am I doing wrong? 

Thank you,
Susan

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: syntax of \copy
Следующее
От: Thom Brown
Дата:
Сообщение: Re: How to run queries without double quotes on tables and columns