SQL Identifiers and key words Documents Needs to be updated

[shaikhnazer]

Summary

While going through the below SQL Identifiers and keywords documents you will find the following sentence:

"SQL identifiers and keywords must begin with a letter (a-z or A-Z). Subsequent characters in an identifier or keyword can be letters, underscores, digits (0-9), dollar signs ($), or the number sign (# )."

https://www.enterprisedb.com/docs/epas/latest/reference/sql_reference/01_sql_syntax/02_identifiers_and_key_words/

Based on the above, it seems that tables starting with "_" cannot be created. but It is created successfully.

In my opinion, the content in the EPAS manual and the actual operation are different.

Tested on EPAS 16.1:

postgres=# create table _test(a integer);
CREATE TABLE

We need to update SQL Identifiers and keywords documents as the Postgresql community already has updated documents.

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

Postgresql community Doc:

"SQL identifiers and key words must begin with a letter (a-z, but also letters with diacritical marks and non-Latin letters) or an underscore (_). Subsequent characters in an identifier or key word can be letters, underscores, digits (0-9), or dollar signs ($). Note that dollar signs are not allowed in identifiers according to the letter of the SQL standard, so their use might render applications less portable. The SQL standard will not define a key word that contains digits or starts or ends with an underscore, so identifiers of this form are safe against possible conflict with future extensions of the standard."

Where would you like to see this added?

https://github.com/EnterpriseDB/docs/blob/main/advocacy_docs/community/contributing/index.mdx

https://www.enterprisedb.com/docs/epas/latest/reference/sql_reference/01_sql_syntax/02_identifiers_and_key_words/

Rationale

No response