2 ms·
Postgres stores and refers to your tables in lowercase (even though you can reference them case insensitively) so naming conventions that involve case don't rea
by Boxxed 2y ago
Postgres stores and refers to your tables in lowercase (even though you can reference them case insensitively) so naming conventions that involve case don't really work.
- Kwpolska 2y agoSome ORMs will use a "camelCaseNameInQuotes", in which case PostgreSQL will preserve the case (as will other databases), and manual querying will require quotes everywhere. Alternatively, you can use camelCase without quotes in your SQL, and ignore the fact that Postgres will lowercase it.
- levkk 2y agoYou just need to quote your identifiers with double quotes, e.g.: SELECT * FROM "MyTable" You can even use reserved SQL keywords in table/column names as long as they are double-quoted.
- Izkata 2y agoWith quotes you can even use spaces in table and column names.