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