Edwin UY <edwin(dot)uy(at)gmail(dot)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