[GENERAL] How to inherit search_path from template

2010-09-09 Thread Phui Hock
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'

Re: [GENERAL] How to inherit search_path from template

2010-09-11 Thread Phui Hock
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