Thread: How to list installed pl languages

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

thanks

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 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

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

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/