Re: [GENERAL] unable to restore. pg_restore: implied data-only restore

2011-05-24 Thread Tom Lane
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 =

Re: [GENERAL] unable to restore. pg_restore: implied data-only restore

2011-05-24 Thread Tim Uckun
> > 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

Re: [GENERAL] unable to restore. pg_restore: implied data-only restore

2011-05-24 Thread Tom Lane
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