Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres query doesn't accept double quote around schema name in query statement - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Postgres query doesn't accept double quote around schema name in query statement
Date
Msg-id FA08145B-B278-45C1-956A-D41C00EB7E80@thebuild.com
Whole thread Raw
In response to Postgres query doesn't accept double quote around schema name in query statement  (Michael Xu <online.mxu@gmail.com>)
List pgsql-general
Tree view 

> 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 by date:

Previous
From: Michael Xu
Date:
Subject: Postgres query doesn't accept double quote around schema name in query statement
Next
From: Tom Lane
Date:
Subject: Re: Postgres query doesn't accept double quote around schema name in query statement