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