Tim Uckun <timuckun@xxxxxxxxx> 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 = 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. The comments are not a problem, but in all but the simplest DB designs there are likely to be some embedded references to the schema name, too. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
