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 по дате отправления: