Quick Links

query to get the list of key (reserverd) words?

From:	Bill Moran <wmoran(at)potentialtech(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	query to get the list of key (reserverd) words?
Date:	2011-08-04 12:53:29
Message-ID:	20110804085329.bb284b20.wmoran@potentialtech.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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?

	From	Date	Subject
Next Message	Steven Boyd	2011-08-04 13:04:38
Previous Message	Gergely Buday	2011-08-04 12:06:39	Re: failed to start postgresql service