PostgreSQL treats all unquoted identifiers—such as table names, column names, and other object names as lowercase by default. This means that if you create a table or column using uppercase letters without double quotes, PostgreSQL will automatically convert the name to lowercase.

A similar question on the following link