Case sensitivity in PostgreSQL
When I started using PostgreSQL, it seemed odd that when I created a table called Users with column names like userId, userPassword, etc. When I would select these items from the table, the column and table names would all be in lowercase. It's quite simple really, I wasn't using quotes :) Below is an example of how to maintain your case in PostgreSQL:
This will all come out lowercase
Whereas this will come out as you expect it to
This will all come out lowercase
create table Users ( userId integer unique not null, userFirstName varchar(50) not null, userLastName varchar(50) not null );
Whereas this will come out as you expect it to
create table "Users" ( "userId" integer unique not null, "userFirstName" varchar(50) not null, "userLastName" varchar(50) not null );