Re: GeSHi module for Postgresql?

Leif Biberg Kristensen wrote:
> On Monday 3. May 2010 23.05.54 Richard Broersma wrote:
> > On Mon, May 3, 2010 at 1:49 PM, Leif Biberg Kristensen
> > <leif@solumslekt.org> wrote:
> > > I
> > > wonder if there' s a compiled list somewhere of just the PostgreSQL
> keywords
> > > and function names. That would be of great help.
> >
> > These are what I know of:
>
> Richard, thank you.
>
> > http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html
>
> That list is a table with descriptions etc, but I can extraxt the keywords
> with a little Perl magic.

Why wouldn't you simply ask Postgres?

select * from pg_get_keywords();

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.