Tim Uckun <timuckun@gmail.com> 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
