Need PostgreSQL Key words list

Started by PG Bug reporting formabout 8 years ago5 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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

#2Bruce Momjian
bruce@momjian.us
In reply to: PG Bug reporting form (#1)
Re: Need PostgreSQL Key words list

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 +
#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: PG Bug reporting form (#1)
Re: Need PostgreSQL Key words list

=?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

#4Pavel Luzanov
p.luzanov@postgrespro.ru
In reply to: Bruce Momjian (#2)
Re: Need PostgreSQL Key words list

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.

-----
Pavel Luzanov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

#5Bruce Momjian
bruce@momjian.us
In reply to: Pavel Luzanov (#4)
Re: Need PostgreSQL Key words list

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 +