Skip to content

Quotes in table names and fields names in Postgres

It is not recommended to use quotes in names, or simple use "Select * ...".  It's not required unless the column names contains reserved words, or have name outside of a to z (upper and lower) and underscore. Regardless types of database, e.g. MySql, Postgres, SQL Server etc, it's generally a good practice to create column name within those confined for future compatibilities. 

Feedback and Knowledge Base