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

Re: Global / cluster-wide functions

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: kevin kempter <kevin(at)kevinkempterllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Global / cluster-wide functions
Date: 2008-05-16 21:25:30
Message-ID: 20080516142530.0ba81186@jd-laptop (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, 16 May 2008 15:12:02 -0600
kevin kempter <kevin(at)kevinkempterllc(dot)com> wrote:

> Hi List;
> 
> Can I install a PL/pgSQL function so it's global to all databases  
> within a cluster or do I need to install per database ?
> 

Install it into template1 then each database created after that will
have the function.

Joshua D. Drake

> 
> Thanks in advance
> 


-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate


In response to

Responses

pgsql-admin by date

Next:From: Phillip SmithDate: 2008-05-19 00:05:03
Subject: Re: pg_restore test procedures (a bit OT)
Previous:From: kevin kempterDate: 2008-05-16 21:12:02
Subject: Global / cluster-wide functions

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