Postgres Pro
Downloads
Home   >   mailing lists

Thread: Keywords

Keywords

From
"vyang"
Date:
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

Re: Keywords

From
Adam Cornett
Date:
On Wed, Jan 11, 2012 at 11:03 AM, vyang <vyang@apt-cafm.com> wrote:
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

The Manual has a list in the appendix:

Re: Keywords

From
Dmitriy Igrishin
Date:
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.


Re: Keywords

From
Adam Cornett
Date:


On Wed, Jan 11, 2012 at 12:02 PM, Adam Cornett <adam.cornett@gmail.com> wrote:
On Wed, Jan 11, 2012 at 11:03 AM, vyang <vyang@apt-cafm.com> wrote:
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

The Manual has a list in the appendix:

Sorry for not reading the first part of your question, you've already found the list I pointed you to.

Why can't you just save the list in Appendix C and read it in to your application?

-Adam

Re: Keywords

From
"vyang"
Date:
 
 
Sent: Wednesday, January 11, 2012 11:05 AM
To: vyang
Subject: Re: [GENERAL] Keywords
 
I want to grab it programmatically because from time to time words are added/removed.
On Wed, Jan 11, 2012 at 12:02 PM, Adam Cornett <adam.cornett@gmail.com> wrote:
On Wed, Jan 11, 2012 at 11:03 AM, vyang <vyang@apt-cafm.com> wrote:
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
 
The Manual has a list in the appendix:

Sorry for not reading the first part of your question, you've already found the list I pointed you to.
 
Why can't you just save the list in Appendix C and read it in to your application?
 
-Adam

Re: Keywords

From
"vyang"
Date:
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.