Rich Shepard <rshepard(at)appl-ecosys(dot)com> writes:
> Running -9.6.1. I have a database created and owned by me, but cannot copy
> a table to my home directory. Postgres tells me it cannot write to that
> directory. The only way to copy tables to files is by doing so as the
> superuser (postgres).
> Why is this, and can I change something so I, as a user, can copy tables
> directly to ~/?
Use psql's \copy instead.
regards, tom lane