Hacker News Reader

Comment by Boxxed | Hacker News Reader

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.

View on HN

You 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.

With quotes you can even use spaces in table and column names.

Some 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.

Reply on news.ycombinator.com