Schema-qualified statements in pg_dump output
| От | Bernd Helmle |
|---|---|
| Тема | Schema-qualified statements in pg_dump output |
| Дата | |
| Msg-id | FF62236EACF7739BC1C3AEC0@imhotep.credativ.de обсуждение исходный текст |
| Ответы |
Re: Schema-qualified statements in pg_dump output
Re: Schema-qualified statements in pg_dump output |
| Список | pgsql-hackers |
There's a behavior in pg_dump that annoyed me a little bit, the last few
times i had to deal with it:
Consider you have to dump a specific namespace only, you are going to use
pg_dump -n <your_schema> [-t <tables>].
I found it a common use case to restore this dump into a different schema
by simply changing the search_path. With included ownerships this doesn't
work, since pg_dump always outputs the necessary DDL as follows:
ALTER TABLE bernd.foo OWNER TO bernd;
Okay, it isn't too hard to use sed to replace the necessary statements to
use the correct schema, but i think it would be much nicer if pg_dump would
omit the schema-qualified table name here. I'd like to create a patch for
this, if we agree on changing this behavior?
-- Thanks
Bernd
В списке pgsql-hackers по дате отправления: