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@xxxxxxxxxx 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings