Get a partial database dump that can be restored to a different user
How to dump a PostgreSQL database in such a way that restoring to a slightly different version of PostgreSQL on a different machine using perhaps a different user will not be a problem:
pg_dump \
--file=/path/to/dump/file.dump \
--format=custom \
--ignore-version \
--schema=public \
--schema=otherschema \
--no-owner \
--verbose \
--no-privileges \
-U user -h myhost mydatabase