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

[Christophe Pettus]

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