Re: pg_dump and schema names

On Mon, Aug 12, 2013 at 12:28:26PM -0400, Peter Eisentraut wrote:
> 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.

True.  I think the larger issue is that we use search_path to avoid
specifying the schema name in lots of places, and SET OWNER should do
the same.  I think the schema reload case is just a side-effect.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +