"Joeseph Blowseph" <joseph_blowseph(at)hotmail(dot)com> writes:
> However, if I run a restore, connecting as the new user, the tables are
> owned by the user as expected, but they are going to the default tablespace
> and blowing my C: filesystem.
If that's a pg_dump dump, it very likely includes commands to specify
which tablespace the tables should go into. You'll need to modify the
dump file to override that.
It might work to create a new database with the desired tablespace as
its default, and restore into that database.
regards, tom lane