Re: Is there a way to check if objects are created with quotes or not?

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