On Tue, Aug 30, 2011 at 1:20 PM, Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:
In this case, it's not about YOU and your permissions, it's about the server. The COPY command writes data as the 'postgres' operating system user (or whichever user owns the postgres backend process).
--Scott
On Aug 30, 2011, at 11:14 AM, Rich Shepard wrote:
> The permissions on that directory are 755 and it's owned by me. Since I
> have no problems writing other files to that directory I must have the
> command syntax incorrect but I don't see where.
In this case, it's not about YOU and your permissions, it's about the server. The COPY command writes data as the 'postgres' operating system user (or whichever user owns the postgres backend process).
--Scott
Where is the server and where are you? You are issuing a command to the server to create a file at that path on the server.
--
Scott Ribe
scott_ribe@xxxxxxxxxxxxxxxx
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
