Re: [GENERAL] COPY to question - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] COPY to question
Date
Msg-id 30889.1484677735@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] COPY to question  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: [GENERAL] COPY to question
Next
From: Rich Shepard
Date:
Subject: Re: [GENERAL] COPY to question [ANSWERED]