Re: pg_dump and schema names

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: pg_dump and schema names
Date: 2013-08-12 16:28:26
Message-ID: 52090D2A.1000600@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 8/9/13 12:04 AM, Bruce Momjian wrote:
> generates this output:
>
> SET search_path = xx, pg_catalog;
> CREATE TABLE test (
> x integer
> );
>
> If you dump a schema and want to reload it into another schema, you
> should only need to update that one search_path line.

Is anyone actually using that feature? It doesn't seem very reliable.
You can't just change the schema name in one or two places. You'd have
to manually inspect function source code, for example.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2013-08-12 16:37:09 Re: question about HTTP API
Previous Message Jeff Janes 2013-08-12 16:27:02 Re: killing pg_dump leaves backend process