Advanced Server Keywords v10
A keyword is a word that is recognized by the Advanced Server parser as having a special meaning or association. You can use the
pg_get_keywords() function to retrieve an up-to-date list of the Advanced Server keywords:
pg_get_keywords returns a table containing the keywords recognized by Advanced Server:
wordcolumn displays the keyword.
catcodecolumn displays a category code.
catdesccolumn displays a brief description of the category to which the keyword belongs.
Note that any character can be used in an identifier if the name is enclosed in double quotes. You can selectively query the
pg_get_keywords() function to retrieve an up-to-date list of the Advanced Server keywords that belong to a specific category:
R - The word is reserved. Reserved keywords may never be used as an identifier, they are reserved for use by the server.
U - The word is unreserved. Unreserved words are used internally in some contexts, but may be used as a name for a database object.
T - The word is used internally, but may be used as a name for a function or type.
C - The word is used internally, and may not be used as a name for a function or type.
For more information about Advanced Server identifiers and keywords, see to the PostgreSQL core documentation at: