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

On 4/27/23 17:58, Michael Xu wrote: Please reply to list also. Ccing list. 1) Are you sure whatever client you are using is not doing "ads.MyTableName"? Confirm, it is not ads.MyTableName. 1) What client(and it's version) are you using? 2) What I asked was whether the schema and table nam

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

> On Apr 27, 2023, at 12:40 PM, Michael Xu wrote: > >  > Hi, > > By default, pgsql accepts double quotes around schema's name in a query, e.g. > select * from "ads"."MyTableName". In our env, it throws 42P01:relation > "ads.MyTableName" does not exist. It is okay if no double quote around s

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

On 4/27/23 12:40, Michael Xu wrote: Hi, By default, pgsql accepts double quotes around schema's name in a query, e.g. select * from "ads"."MyTableName". In our env, it throws 42P01:relation "ads.MyTableName" does not exist. It is okay if no double quote around schema name, select * from ads."

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

> On Apr 27, 2023, at 12:40, Michael Xu 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-sensiti

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

Michael Xu writes: > By default, pgsql accepts double quotes around schema's name in a query, > e.g. select * from "ads"."MyTableName". In our env, it throws > 42P01:relation "ads.MyTableName" does not exist. Works for me: regression=# create schema ads; CREATE SCHEMA regression=# create table "