I'm using pg_dump (9.2 database), to extract one schema and load this into another database (9.4).
well, here's the command:
pg_dump -f file.sql -F plain --inserts -n schema database
Ok. My command finished up really nice, but, it's not dumping everything to a schema called schema (in the example above). It's loading everything into public.
To make the question clearer:
The dump works fine. Upon inspection, it's dumping my
schema.table, for example, to
public.table. I want that to restored to schema, not public.
Any tips on solving this?