Re: Schema-qualified statements in pg_dump output
От | Joshua D. Drake |
---|---|
Тема | Re: Schema-qualified statements in pg_dump output |
Дата | |
Msg-id | 1216743965.6971.129.camel@jd-laptop обсуждение исходный текст |
Ответ на | Re: Schema-qualified statements in pg_dump output (Simon Riggs <simon@2ndquadrant.com>) |
Список | pgsql-hackers |
On Tue, 2008-07-22 at 16:58 +0100, Simon Riggs wrote: > On Mon, 2008-07-21 at 23:53 -0400, Owen Hartnett wrote: > 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_dump --relocateable-schema (or alternate option name) > > Then when we reload, we just run > > psql -f pgdump.file -v PGDUMPSCHEMA=newlocation I like the idea but would prefer no shell variable (I assume that is what you are using above). Why not just -X target-schema=newlocation or something like that? Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
В списке pgsql-hackers по дате отправления: