KEYWORDS

Identifies Vertica reserved and non-reserved 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