Re: Howto see template objects in PGAdmin3

On 02/14/2013 03:11 PM, John R Pierce wrote:
> On 2/14/2013 7:06 AM, James B. Byrne wrote:
>> CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
>
> plpgsql is a LANGUAGE, not an extension, I thought?
>
> you use CREATE LANGUAGE to enable it..
>

http://www.postgresql.org/docs/9.2/interactive/sql-createlanguage.html

Note: As of PostgreSQL 9.1, most procedural languages have been made
into "extensions", and should therefore be installed with CREATE
EXTENSION not CREATE LANGUAGE. Direct use of CREATE LANGUAGE should now
be confined to extension installation scripts. If you have a "bare"
language in your database, perhaps as a result of an upgrade, you can
convert it to an extension using CREATE EXTENSION langname FROM unpackaged.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com