Re: Keywords

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: vyang <vyang(at)apt-cafm(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Keywords
Date: 2012-01-11 17:03:28
Message-ID: CAAfz9KNTGV4boExab7a1_xSazZTbJyEtZeuRwEmxPqtD4Y+gDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

  • Keywords at 2012-01-11 16:03:21 from vyang

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Cornett 2012-01-11 17:05:36 Re: Keywords
Previous Message Adam Cornett 2012-01-11 17:02:41 Re: Keywords