When do Postgres column or table names need quotes and when don’t they?

by

PostgreSQL converts all names (table name, column names etc) into lowercase if you don’t prevent it by double quoting them in create table "My_Table_ABC" ( "My_Very_Upper_and_Lowercasy_Column" numeric,...). If you have names like this, you must always double quote those names in selects and other references.

I would recommend not creating tables like this and also not using chars outside a-z, 0-9 and _. You can not guarantee that every piece of software, library etc ever to be used against your database will support case-sensitivity. It’s also tedious to remember and doing this double quoting.

More Related Contents:

  1. SQL query column does not exist error
  2. Strange behaviour in Postgresql
  3. Insert, on duplicate update in PostgreSQL?
  4. How does the search_path influence identifier resolution and the “current schema”
  5. How do you find the row count for all your tables in Postgres
  6. Run batch file with psql command without password
  7. invalid byte sequence for encoding “UTF8”
  8. Postgresql: Conditionally unique constraint
  9. How do you use variables in a simple PostgreSQL script?
  10. How to switch databases in psql?
  11. Postgresql: Scripting psql execution with password
  12. Cannot create a database table named ‘user’ in PostgreSQL
  13. Postgresql Truncation speed
  14. Buffers (Circle) in PostGIS
  15. docker postgres pgadmin local connection
  16. How to customize the configuration file of the official PostgreSQL Docker image?
  17. Error: Column does not exist
  18. Does a Postgres UNIQUE constraint imply an index?
  19. Postgresql Column Not Found, But Shows in Describe
  20. Heroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  21. Dynamically generate columns for crosstab in PostgreSQL
  22. Postgresql insert trigger to set value
  23. How can I get a list of all functions stored in the database of a particular schema in PostgreSQL?
  24. PostgreSQL how to concat interval value ‘2 days’
  25. Displaying image in Ireports using PostgreSql
  26. Orbeon Forms Postgres DB connection
  27. How to delete an enum type value in postgres?
  28. Why unsigned integer is not available in PostgreSQL?
  29. What’s the difference between pg_table_size, pg_relation_size & pg_total_relation_size? (PostgreSQL)
  30. JPA and PostgreSQL with GenerationType.IDENTITY

Leave a Comment