Postgres Pro
Downloads
Home   >   mailing lists

Re: Keywords - Mailing list pgsql-general

From Dmitriy Igrishin
Subject Re: Keywords
Date
Msg-id CAAfz9KNTGV4boExab7a1_xSazZTbJyEtZeuRwEmxPqtD4Y+gDw@mail.gmail.com
Whole thread Raw
In response to Keywords  ("vyang" <vyang@apt-cafm.com>)
Responses Re: Keywords  ("vyang" <vyang@apt-cafm.com>)
List pgsql-general
Tree view
Hey vyang,

2012/1/11 vyang <vyang@apt-cafm.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.


pgsql-general by date:

Previous
From: Adam Cornett
Date:
Subject: Re: Keywords
Next
From: Adam Cornett
Date:
Subject: Re: Keywords