Re: How to list installed pl languages

From: "Dennis" <dennis(at)kabonkulator(dot)com>
To: <depesz(at)depesz(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to list installed pl languages
Date: 2011-11-10 14:32:51
Message-ID: 002701cc9fb5$a0963fc0$e1c2bf40$@kabonkulator.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)depesz(dot)com [mailto:depesz(at)depesz(dot)com]
Sent: Thursday, November 10, 2011 7:07 AM
To: Dennis Ryan
Cc: pgsql-general(at)postgresql(dot)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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message shuaixf 2011-11-10 14:43:40 How to inquiry a nest result?
Previous Message David Johnston 2011-11-10 14:29:18 Re: plpgsql, I have a solution, want to see if there is a cleaner/better one. Taking vertical list and comma separating it onto a row