On 20 December 2011 15:35, Adrian Klaver <adrian.kla...@gmail.com> wrote: > To elaborate on my previous answer, search_path is in postgresql.conf because > it > is tied to the database cluster not a particular database.
Not necessarily, it can also be tied to a schema or a role or (I assume) a specific database in the cluster. ALTER ROLE x SET search_path TO ... ALTER SCHEMA x SET search_path TO ... I don't have a PG instance available here, so I can't verify whether those get dumped/restored. I assume they do though. -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
