Re: Pg_dump does not include database search path in backup file - Mailing list pgsql-admin

"Richard Harris" <Richard_Harris@adp.com> writes:
> I'm using PostgreSQL 7.4.2. I have a database with several user defined
> schemas, e.g., public, shr, sys, acc, prt. I have altered the database
> search path to include all of the schema.

> ALTER DATABASE adp_test_db SET search_path to public, shr, sys, acc,
> prt, svc, fi;

> Then I used psql to restore the database from the backup file. However,
> psql restored the search path to the default (e.g., $user, public)
> rather than the search path with all the schemas.

pg_dump only dumps the contents of the database.  Settings associated
with ALTER DATABASE or ALTER USER are considered to be the province
of pg_dumpall.

            regards, tom lane