Skip to content

Instantly share code, notes, and snippets.

@pH-7

pH-7/preserve-caps-column-names-postgresql.md

Created December 19, 2022 07:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pH-7/53740a9370813a54c3e16c436c8aae8a to your computer and use it in GitHub Desktop.
Save pH-7/53740a9370813a54c3e16c436c8aae8a to your computer and use it in GitHub Desktop.
Download ZIP
Preserve cases of column/table names with PostgreSQL
Raw
preserve-caps-column-names-postgresql.md

If you name your PostgreSQL table names or column names with caps like lowerCamel / UpperCamel cases, you will need to surround the column names/table name with double quotes to preserve the case of their names since our the columns in our database are lowerCamel case. Otherwise, Postgres wouldn’t find them as it would look for lowercase-only names.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment