How to display double quotes in Postgres/pgAdmin column

142 Views Asked by At

In my new workplace, some of table have column name wrapped with double quote and some of them is not. It's somewhat confusing for me to do some query. So I want to try standardize that to wrapped all column with double quote.

But I really don't know is this column have double quote or not until i do query with the table. Is there any settings to display whether column is wrapped by double quote ot not in postgres especially in pgAdmin since I use that?

*since there are many table there. i think its really time consuming to check 1 by 1 with query

0

There are 0 best solutions below