Re: pg_dump and alter database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: btober(at)seaworthysys(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump and alter database
Date: 2003-08-22 14:20:08
Message-ID: 10141.1061562008@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<btober(at)seaworthysys(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-08-22 14:24:51 Re: Schema
Previous Message Carmen Gloria Sepulveda Dedes 2003-08-22 14:12:05 Schema