How to list installed pl languages

On Wed, Nov 09, 2011 at 10:58:01PM -0600, Dennis Ryan wrote:

Is there a way to list the installed pl languages for a database
and/or server cluster?

\dL in psql
or
select * from pg_language;

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/

On Thursday 10 November 2011 05:58:01 Dennis Ryan wrote:

Is there a way to list the installed pl languages for a database and/or
server cluster?

they are registered in the pg_language system catalog.

Rgds, Jens

On Wednesday, November 09, 2011 8:58:01 pm Dennis Ryan wrote:

Is there a way to list the installed pl languages for a database and/or
server cluster?

aklaver@tucker:~$ createlang -l -U postgres test
Procedural Languages
Name | Trusted?
-----------+----------
plpgsql | yes
plpythonu | no

thanks

--
Adrian Klaver
adrian.klaver@gmail.com

Thanks the select * from pg_language works and is exactly what I was looking for. \dL in psql does not in my version, 9.0.4.14, however \dL did work on another install of version 9.1.1.

Thanks for the help.

-----Original Message-----
From: depesz@depesz.com [mailto:depesz@depesz.com]
Sent: Thursday, November 10, 2011 7:07 AM
To: Dennis Ryan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to list installed pl languages

On Wed, Nov 09, 2011 at 10:58:01PM -0600, Dennis Ryan wrote:

Is there a way to list the installed pl languages for a database
and/or server cluster?

\dL in psql
or
select * from pg_language;

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/