Request a Demo
Home   >   mailing lists

Re: Is there a way to check if objects are created with quotes or not? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Is there a way to check if objects are created with quotes or not?
Date
Msg-id 3505849.1737507149@sss.pgh.pa.us
Whole thread Raw
In response to Is there a way to check if objects are created with quotes or not?  (Edwin UY <edwin.uy@gmail.com>)
List pgsql-admin
Tree view 
Edwin UY <edwin.uy@gmail.com> writes:
> I am just now finding out that I sometimes I have to enclosed tables in
> quotes, that is a name named table1 need to be quoted as 'table1' otherwise
> it gives error.

"table1" shouldn't need quotes.  The rules for that are here:

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Commit with wait event on advisory lock!
Next
From: Gurjeet Singh
Date:
Subject: Re: Is there a way to check if objects are created with quotes or not?