Skip site navigation (1) Skip section navigation (2)

Re: Adding support for plpgsql

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: Mike Cianflone <mcianflone(at)littlefeet-inc(dot)com>
Cc: "'pgsql-docs(at)postgresql(dot)org'" <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Adding support for plpgsql
Date: 2001-05-02 20:05:06
Message-ID: 20010502140506.B19921@cc.usu.edu (view raw or flat)
Thread:
Lists: pgsql-docs
On Wed, May 02, 2001 at 10:46:51AM -0700, Mike Cianflone wrote:
> 	I'm trying to create a procedure that uses plpgsql, but the db tells
> me that that language is not supported when creating the function. I copied
> an example for creating the function using plpgsql. I see the CREATE
> PROCEDURAL LANGUAGE command in the manual, but does plpgsql come standard?
> Do I need to install an optional package to get the db to recognize plpgsql
> functions?

	Use the "createlang" command (as postgres):

	createlang plpgsql mydb

	where "mydb" is your database name. If you do a createlang on the
template1 database, it'll be added to any other databases you create by
default.

	-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
Rauchen ist super: es vernichtet alle Raucher...

In response to

pgsql-docs by date

Next:From: Bruce MomjianDate: 2001-05-02 20:33:43
Subject: Re: Developer vs. Programmer
Previous:From: Roberto MelloDate: 2001-05-02 20:02:38
Subject: Re: Developer vs. Programmer

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group