> > 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 = public, pg_catalog; At the top and it might work. However I do see a lot of comments with the schema name in them like. -- -- TOC entry 18 (class 1255 OID 16417) -- Dependencies: 6 -- Name: get_text_document(character varying); Type: FUNCTION; Schema: public; Owner: - -- Does pg_restore use these comments in some way? Should I change those as well? > * 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. This might be the easiest way now that I think about it. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
