2017-01-17 19:23 GMT+01:00 Rich Shepard <rshepard@xxxxxxxxxxxxxxx>:
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 ~/?
You cannot to use server side COPY for writing directly to client side directory.
If you use psql console, and there is client side backslash COPY statement. There you can write anywhere on client side, where you have a access.
\COPY table TO ~/xxx.dta
is valid there.
Regards
Pavel
Rich
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
