Re: [GENERAL] COPY to question

Rich Shepard <rshepard@appl-ecosys.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