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