How can I obtain the list of Postgres keywords? Failing a programmatic solution, where can I look inside the Postgres project to get this list?
Context: for use in a code generation tool.
4
-
You can get it from the source code: github.com/postgres/postgres/tree/master/doc/src/sgml/keywordsFrank Heikens– Frank Heikens2025-01-22 04:43:28 +00:00Commented Jan 22 at 4:43
-
3There is a function pg_get_keywords()klin– klin2025-01-22 04:47:56 +00:00Commented Jan 22 at 4:47
-
@klin, your comment would do a good candidate for an answer: although it doesn't reply directly, it resolves Mark's initial need that was to get them programmatically.Guillaume Outters– Guillaume Outters2025-01-22 11:03:36 +00:00Commented Jan 22 at 11:03
-
I hope the OP doesn't mind if I mark his question as a duplicate.klin– klin2025-01-22 11:12:28 +00:00Commented Jan 22 at 11:12
Add a comment
|
1 Answer
In the source of PostgreSQL,
you will see that doc/src/sgml/generate-keywords-table.pl combines the contents of:
- every doc/src/sgml/keywords/sql*-*.txt (standard SQL)
- as well as the contents of src/include/parser/kwlist.h (PostgreSQL specifics)
You can even run it directly from the source tree:
perl ./doc/src/sgml/generate-keywords-table.pl doc/src/sgml |
sed -e '/<token>/!d' -e 's/ *<[^>]*>//g' -e 's/&zwsp;//g'
