On Thu, Sep 9, 2010 at 7:13 AM, Phui Hock <phuih...@gmail.com> 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 database. You can however set them on the role and use them that way -- that will probably work in your case. Just make a role for each database. Another thing you can do is have your app immediately set your search path upon login -- not a connection pooler friendly approach though. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
