From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | krishnaa sridharan <kichi(at)rediffmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pl/pgsql help |
Date: | 2005-10-25 09:19:35 |
Message-ID: | 1130231975.30145.108.camel@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)lfix(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2005-10-25 09:21:06 | Re: pg_dump, MVCC and consistency |
Previous Message | WireSpot | 2005-10-25 09:18:34 | Re: Deleting vs foreign keys |