KEYWORDS

Identifies Vertica reserved and non-reserved keywords.

Column Name Data Type Description
KEYWORD VARCHAR Vertica‑reserved or non-reserved keyword.
RESERVED VARCHAR Indicates whether a keyword is reserved or non-reserved:
  • R: reserved
  • N: non-reserved

Examples

The following query gets all reserved keywords that begin with B:

=> SELECT * FROM keywords WHERE reserved = 'R' AND keyword ilike 'B%';
 keyword | reserved
---------+----------
 BETWEEN | R
 BIGINT  | R
 BINARY  | R
 BIT     | R
 BOOLEAN | R
 BOTH    | R
(6 rows)

See Also

Keywords