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 for naming database objects, you could achieve that by putting the identifier name in double quotes. PostgreSQL identifier names have the following constraints:

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

In addition to the preceding points, it is not recommended to use keywords as table names.