Postgres Pro
Downloads
Home   >   mailing lists

Re: Keywords - Mailing list pgsql-general

From vyang
Subject Re: Keywords
Date
Msg-id 662DE615139F456BBFE519B489F9FBFA@vyang
Whole thread Raw
In response to Re: Keywords  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-general
Tree view
That works perfectly.  Thanks!!
 
Sent: Wednesday, January 11, 2012 11:03 AM
To: vyang
Subject: Re: [GENERAL] Keywords
 
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: "vyang"
Date:
Subject: Re: Keywords
Next
From: Kirill Müller
Date:
Subject: Re: Enumeration of tables is very slow in largish database