Thread: Need PostgreSQL Key words list
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/sql-keywords-appendix.html Description: Hi, Some people developing code formatting/highlighting plugins use this table as the list of PostgreSQL key words: https://www.postgresql.org/docs/current/static/sql-keywords-appendix.html However, that list isn't complete, eg. TIMESTAMPTZ, JSON, UUID... are missing, probably because these aren't in SQL standard. Would you please consider having a full list of PostgreSQL Key words, either in that table, or somewhere else? Thanks
On Tue, Jan 30, 2018 at 08:18:27AM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/static/sql-keywords-appendix.html > Description: > > Hi, > > Some people developing code formatting/highlighting plugins use this table > as the list of PostgreSQL key words: > https://www.postgresql.org/docs/current/static/sql-keywords-appendix.html > > However, that list isn't complete, eg. TIMESTAMPTZ, JSON, UUID... are > missing, probably because these aren't in SQL standard. > > Would you please consider having a full list of PostgreSQL Key words, either > in that table, or somewhere else? The most current keyworsd list is in our source tree: https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/include/parser/kwlist.h;h=26af944e03a1109210d36060fc9acebc1b6ffa20;hb=HEAD However, that doesn't have TIMESTAMPTZ or JSON because those are data types, not keywords. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +
=?utf-8?q?PG_Doc_comments_form?= <noreply@postgresql.org> writes:
> However, that list isn't complete, eg. TIMESTAMPTZ, JSON, UUID... are
> missing, probably because these aren't in SQL standard.
Those are not key words. They're just names.
regards, tom lane
On 30.01.2018 16:08, Bruce Momjian wrote:
And this list is accessible through the pg_get_keywords() function.The most current keyworsd list is in our source tree:
----- Pavel Luzanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
On Tue, Jan 30, 2018 at 05:30:59PM +0300, Pavel Luzanov wrote: > On 30.01.2018 16:08, Bruce Momjian wrote: > > The most current keyworsd list is in our source tree: > > And this list is accessible through the pg_get_keywords() function. Sorry, yes, I forgot we added that long ago. Thanks. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +