PostgreSQL identifiers

The length of PostgreSQL object names is 63 characters; PostgreSQL also follows ANSI SQL regarding case-sensitivity. If you wanted to use camel case or restricted symbols, such as dashes to name database objects, you could achieve that by putting the identifier name in double quotes. PostgreSQL identifier names have the following constraints:

• The identifier name should start with an underscore or a letter. Letters can be Latin or non-Latin.
• The identifier name can be composed of letters, digits, underscore, and the dollar sign. For compatibility reasons, the use of the dollar sign isn't recommended.
• The minimum length of the identifier is typically 1 character, and the maximum length is 63.

In addition to the preceding points, it isn't recommended to use keywords as table names.