> -----Original Message----- > From: Bill Moran [mailto:wmoran@xxxxxxxxxxxxxxxxx] > Sent: Thursday, August 04, 2011 8:53 AM > To: pgsql-general@xxxxxxxxxxxxxx > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
