Re: pl/pgsql help - Mailing list pgsql-general

From Oliver Elphick
Subject Re: pl/pgsql help
Date
Msg-id 1130231975.30145.108.camel@linda.lfix.co.uk
Whole thread Raw
In response to pl/pgsql help  ("krishnaa sridharan" <kichi@rediffmail.com>)
List pgsql-general
On Tue, 2005-10-25 at 00:17 +0000, krishnaa sridharan wrote:
> Hi all
> When I installed postgresql in my computer, I had pl/pgsql language
> selected but still, I dont have any language installed. Can some one
> tell me how to install a language. thanks in advance. i am a beginner
> so any help would be appreciated.

CREATE LANGUAGE plpgsql;

If you do that in the template1 database, every database created
thereafter will have it installed from scratch.

--
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
   Do you want to know God?   http://www.lfix.co.uk/knowing_god.html


pgsql-general by date:

Previous
From: WireSpot
Date:
Subject: Re: Deleting vs foreign keys
Next
From: Martijn van Oosterhout
Date:
Subject: Re: pg_dump, MVCC and consistency