Tim Uckun writes:
>> There is no support for that built into pg_dump. You could try:
>> * dumping to a text script and doing search-and-replace for the schema
>> name on the script file.
> I did a dump without privileges or owners so I was thinking I could
> just replace the
> SET search_path =
>
> There is no support for that built into pg_dump. You could try:
That's too bad.
>
> * dumping to a text script and doing search-and-replace for the schema
> name on the script file.
I did a dump without privileges or owners so I was thinking I could
just replace the
SET search_path = publi
Tim Uckun writes:
> I am trying to backup one database and restore it into a new schema in
> another database. Database1 has the tables in the public schema
> database2 has some tables in the public schema but their names will
> clash so the database needs to be stored in a different schema.
Ther
I am trying to backup one database and restore it into a new schema in
another database. Database1 has the tables in the public schema
database2 has some tables in the public schema but their names will
clash so the database needs to be stored in a different schema.
I back up like this.
/usr/bin/
