Re: pg_dump and schema names

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.