I have database1 where postgis is installed in the public schema. And database2 where postgis is located in a schema called postgis.
When I dump database1.schema1, schema1.table1 references its geom column as public.geometry.
Therefore pg_restore throws "schema public does not exists" error because schema1.table1 has public.geometry column and the schema does not exists nor is postgis installed in that schema.
How can I make a clean pg_dump without having schema qualified geometry columns?
The database2 search_path points to the schema postgis. I am using PostgresSQL 10.