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

From: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Is there a way to check if objects are created with quotes or not?
Date: 2025-01-21 23:28:01
Message-ID: CA+wokJ_v+60LbcBcbQmxxLQKZucAedokjrmJ5QMTevyO5q78Kg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

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.
Is there any way to find out what are those such tables so we can rename it
to be without the quotes? Or maybe it is not a good idea to rename as it
might break the indexes / foreign keys / sequences?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message msalais 2025-01-22 00:22:09 RE: Commit with wait event on advisory lock!
Previous Message kasem adel 2025-01-21 18:10:13 High Disk Utilization Due to Query on Large Table