On Sun, Sep 12, 2010 at 8:34 AM, Scott Marlowe wrote:
> On Thu, Sep 9, 2010 at 7:41 PM, Merlin Moncure wrote:
>> On Thu, Sep 9, 2010 at 7:13 AM, Phui Hock wrote:
>>> Hi,
>>> How can I create a database template with altered search_path to be
>>> inherited by child databases? Say, I created a tem
On Thu, Sep 9, 2010 at 7:41 PM, Merlin Moncure wrote:
> On Thu, Sep 9, 2010 at 7:13 AM, Phui Hock wrote:
>> Hi,
>> How can I create a database template with altered search_path to be
>> inherited by child databases? Say, I created a template named
>> template_a with the following commands:
>
> It
That answers a lot of my doubts with regard to search_path. Thanks!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Sep 9, 2010 at 7:13 AM, Phui Hock wrote:
> Hi,
> How can I create a database template with altered search_path to be
> inherited by child databases? Say, I created a template named
> template_a with the following commands:
It doesn't really work that way -- GUC values are global, not per
Hi,
How can I create a database template with altered search_path to be
inherited by child databases? Say, I created a template named
template_a with the following commands:
# CREATE DATABASE template_a WITH TEMPLATE template1;
# UPDATE pg_database SET datistemplate=true WHERE
datname='template_a'