Re: Keywords

["vyang" <vyang@xxxxxxxxxxxx>]

That works perfectly.  Thanks!!

 

From: Dmitriy Igrishin

Sent: Wednesday, January 11, 2012 11:03 AM

To: vyang

Cc: pgsql-general@xxxxxxxxxxxxxx

Subject: Re: Keywords

 

Hey vyang,

2012/1/11 vyang <vyang@xxxxxxxxxxxx>

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.