Quick Links

COPY to question

From:	Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	COPY to question
Date:	2017-01-17 18:23:28
Message-ID:	alpine.LNX.2.11.1701171020160.9225@localhost
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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 ~/?

Rich

Responses

Re: COPY to question at 2017-01-17 18:28:55 from Tom Lane
Re: COPY to question at 2017-01-17 18:31:22 from Pavel Stehule
Re: COPY to question at 2017-01-17 18:33:10 from Steve Atkins
Re: COPY to question at 2017-01-17 18:40:10 from David G. Johnston
Re: COPY to question at 2017-01-17 19:39:50 from Steve Crawford

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2017-01-17 18:28:55	Re: COPY to question
Previous Message	kumar s	2017-01-17 16:43:10	Fwd: [webmaster] Update query issue