Re: query to get the list of key (reserverd) words? - Mailing list pgsql-general

From Igor Neyman
Subject Re: query to get the list of key (reserverd) words?
Date
Msg-id F4C27E77F7A33E4CA98C19A9DC6722A207E5E24C@EXCHANGE.corp.perceptron.com
Whole thread Raw
In response to query to get the list of key (reserverd) words?  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general

> -----Original Message-----
> From: Bill Moran [mailto:wmoran@potentialtech.com]
> Sent: Thursday, August 04, 2011 8:53 AM
> To: pgsql-general@postgresql.org
> Subject: query to get the list of key (reserverd) words?
>
>
> I'm in the unenviable position of needing to check various input to
> ensure that it doesn't contain any PostgreSQL/SQL key words/reserved
> words.
>
> The initial implementation simply made a copy of this table:
> http://www.postgresql.org/docs/8.3/static/sql-keywords-
> appendix.html#KEYWORDS-TABLE
> into a static array in the code.  Obviously, this is non-optimal
> because it becomes a manual chore to ensure the list is up to date
> any time new PG releases are made.
>
> Is there a pg_* or other table in the database that I can query for
> this
> list?  Or some other automated method that can be employed?
>
> --
> Bill Moran
> http://www.potentialtech.com
> http://people.collaborativefusion.com/~wmoran/

Use pg_get_keywords(OUT word text, OUT catcode "char", OUT catdesc text)

Regards,
Igor Neyman

pgsql-general by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: hstore installed in a separate schema
Next
From: "David Johnston"
Date:
Subject: Is there a better way to unnest an entire row?