Re: Keywords

That works perfectly. Thanks!!

From: Dmitriy Igrishin
Sent: Wednesday, January 11, 2012 11:03 AM
To: vyang
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Keywords

Hey vyang,

2012/1/11 vyang <vyang(at)apt-cafm(dot)com>

Hello List,

I’m wondering if there is a way to retrieve/query PostgreSQL for a list of key words matching that of Appendix C. SQL Key Words. I’m using PostgreSQL 9.1 and java. I’ve already tried java’s DatabaseMetaData.getSQLKeywords, but the API states “Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.” As a result many key words are left out. Any help on this matter is much appreciated.

vyang

Use pg_get_keywords().
http://www.postgresql.org/docs/9.1/static/functions-info.html

--
// Dmitriy.