Re: pg_restore (fromuser -> touser)

This is true. Such a feature is not available in PostgreSQL.

What you need to do is you have to take a structure dump, and change the
schema name as per required. And, then, you may copy the data.

Regards,
Ninad Shah

On Fri, 23 Jul 2021 at 23:08, Mayan <popalzie(at)gmail(dot)com> wrote:

> Hi,
>
>
>
> I had a general question about a feature that we depended on heavily when
> using other RDBMS providers which was the ability to take a schema dump and
> restore it to a different database and a different schema in that database
> (could be to the same database as well). Basically, there was an option
> on restore to specify a FROMUSER and a TOUSER directive so schema A could
> be restored elsewhere but as schema B.
>
>
>
> I don’t see such an option in Postgres and the only workaround I am aware
> of is to do a plain-text (format=p) and then a crude find/replace to
> replace the old schema name with the new schema name. I’ve never
> actually tested this to be sure even this would work. Also, using this
> option will prevent us from parallelizing the import or export, so it’s
> really not something we want to do.
>
>
>
> This would be a really useful feature in my opinion along with the ability
> to maintain parallelization options.
>
>
>
> Are there any such features on the roadmap? Is my understanding correct
> about the available ways to accomplish this – again, in a practical and
> performant way?
>
>
>
> Thanks,
>
> Mayan
>