Tim Uckun <timuckun@gmail.com> 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.
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.
* temporarily renaming the target database's public schema out of the
way, then renaming after the restore.
* doing the schema rename on the source database before you dump.
regards, tom lane