Обсуждение: Functions with PLpgsql or PLpython

Hi,<br /><br /> I'm using Pgadmin3-1.4.3 and i want to create some functions using PLpgsql or PLpython.<br /><br /> My
problemis that i have no option for that languages.... when i create a function, my options are:<br /><blockquote>-
internal<br/> - c<br /> - sql<br /></blockquote> How to get support for PL languages in pgadmin?<br /><br /> Thanks in
advance<br/><br />     Carlos V.<br /> 

They will show up if they are in your database.  Run create language command for the languages you wish to use.

Thanks for the help :) it worked fine.

    Carlos V.

Ketema J. Harris wrote:

They will show up if they are in your database.  Run create language command for the languages you wish to use.

If you add them to your template db they will be created in any future database you make with that template.

Ex:

create language plperl;

if your db was built with perl support this command will add it to the db.

Ketema J. Harris

www.ketema.net

ketema@ketema.net

On Nov 17, 2006, at 9:41 AM, Carlos Vieira wrote:

Hi,

I'm using Pgadmin3-1.4.3 and i want to create some functions using PLpgsql or PLpython.

My problem is that i have no option for that languages.... when i create a function, my options are:

- internal
- c
- sql

How to get support for PL languages in pgadmin?

Thanks in advance

    Carlos V.