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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +