Re: COPY to question

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY to question
Date: 2017-01-17 18:31:22
Message-ID: CAFj8pRCyC0r1gLgp7u-hGkz-3gUR7ftPcJ1nY+1Lwe1cbO46aw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

2017-01-17 19:23 GMT+01:00 Rich Shepard <rshepard(at)appl-ecosys(dot)com>:

> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2017-01-17 18:33:10 Re: COPY to question
Previous Message Rich Shepard 2017-01-17 18:30:14 Re: COPY to question [ANSWERED]