query to get the list of key (reserverd) words?
| От | Bill Moran |
|---|---|
| Тема | query to get the list of key (reserverd) words? |
| Дата | |
| Msg-id | 20110804085329.bb284b20.wmoran@potentialtech.com обсуждение исходный текст |
| Ответы |
Re: query to get the list of key (reserverd) words?
Re: query to get the list of key (reserverd) words? Re: query to get the list of key (reserverd) words? |
| Список | 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? -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/
В списке pgsql-general по дате отправления: