Thread: 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.
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
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:- internalHow to get support for PL languages in pgadmin?
- c
- sql
Thanks in advance
Carlos V.
Attachment
Thanks for the help :) it worked fine.
Carlos V.
Ketema J. Harris wrote:
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. HarrisOn 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:- internalHow to get support for PL languages in pgadmin?
- c
- sql
Thanks in advance
Carlos V.