Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and alter database - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump and alter database
Date
Msg-id 10141.1061562008@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump and alter database  (<btober@seaworthysys.com>)
Responses Re: pg_dump and alter database  (<btober@seaworthysys.com>)
List pgsql-general
Tree view 
<btober@seaworthysys.com> writes:
> The problem I have is that the SQL DDL and DML produced by pg_dump fails
> to include the ALTER DATABASE ... SET search_path ... statement that sets
> the search path for when I re-load the database from a dump file.

This functionality is in pg_dumpall, not pg_dump.

(Whether that's the right place for it is debatable, perhaps.)

            regards, tom lane

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Schema
Next
From: Dennis Björklund
Date:
Subject: Re: Schema