![](https://cdn.userecho.com/characters/106.png?1)
0
Answered
[PostgreSQL] Add quotes to generated SQL table names and columns
PostgreSQL does not require double quotes around table names and identifiers, it will just lower case them. However, I want them to remain in a certain case in the database. For example, if I add a table Team, I want it to show up as Team, not team. The generated sql will not add any quotes to the name unless it's a reserved keyword. Is there a way for me to add this? I only found this: http://support.vertabelo.com/topic/529465-postgresql-script-generated-ignore-double-quota-set-schema-and-tablespace-name/
but I don't think it's related.
Also with FK, if I have Team_id as a column, it will become team_id in the database w/o quotes. Help?
but I don't think it's related.
Also with FK, if I have Team_id as a column, it will become team_id in the database w/o quotes. Help?
Answer
![](https://cdn.userecho.com/characters/97.png?1)
+1
Answer
Answered
Just check the "Quote all SQL identifiers" checkbox in "SQL generation settings" section:
![](/s/attachments/13484/1/4/fc583de2e0d6231f499845e98ecb80f5.png)
All table and column names will be in double quotes.
![](/s/attachments/13484/1/4/fc583de2e0d6231f499845e98ecb80f5.png)
All table and column names will be in double quotes.
Customer support service by UserEcho
All table and column names will be in double quotes.