Thanks George:
On 12/31/08, George Pavlov <gpavlov@mynewplace.com> wrote:
> Many ways to do it either by creating schemas in the target DBs, or by
> changing search paths (the default one or for the script duration).
> Here's a "one-liner",
> assuming your 4 original databases do not have multiple schemas within
> them:
correct assumption, all of my DBs, have only the public schema
> psql -dmaindb -c"create schema scha"
> pg_dump -Fp -x -O dba | sed 's/SET search_path = public/SET
> search_path = scha/' | psql -dmaindb
Looks simple! After this, would I be able to delete/drop/cascade dba?
--
Regards
PK
--------------------------------------
http://counter.li.org #402424