Re: Postgres query doesn't accept double quote around schema name in query statement

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Postgres query doesn't accept double quote around schema name in query statement
Дата
Msg-id FA08145B-B278-45C1-956A-D41C00EB7E80@thebuild.com
обсуждение исходный текст
Ответ на Postgres query doesn't accept double quote around schema name in query statement  (Michael Xu <online.mxu@gmail.com>)
Список pgsql-general
Дерево обсуждения 

> On Apr 27, 2023, at 12:40, Michael Xu <online.mxu@gmail.com> wrote:
> In our env, it throws 42P01:relation "ads.MyTableName" does not exist.

The function of double quotes in SQL is to allow you do include characters that would otherwise not be legal in an
identifier(as well as making the identifier case-sensitive).  So, you are telling the database that there is a table
named"ads.MyTableName", with the "." included as part of the identifier.

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

Предыдущее
От: Michael Xu
Дата:
Сообщение: Postgres query doesn't accept double quote around schema name in query statement
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres query doesn't accept double quote around schema name in query statement