Re: Schema-qualified statements in pg_dump output - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Schema-qualified statements in pg_dump output
Date
Msg-id 782.1216748106@sss.pgh.pa.us
Whole thread Raw
In response to Re: Schema-qualified statements in pg_dump output  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Schema-qualified statements in pg_dump output
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> No need to specify the name at pg_dump time.
> For text files, just use an option to specify whether we change the
> actual schema name and replace it with the text :PGDUMPSCHEMA.

pg_restore is in even worse position than pg_dump to make this happen;
it would not be able to do anything that's smarter than a sed-like
substitution.

I doubt that the original idea can be made to work, but this
"improvement" will entirely guarantee failure.

(Note: the problem is not so much with the names of the objects you're
directly creating, as with object cross-references that're embedded in
the DDL.)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Postgres-R: primary key patches
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] GIN improvements