On 1/31/23 05:02, Marco Lechner wrote:
Hi,
Using COPY …TO it is possible to store e.g. the “value” of a bytea cell
in a directory on the server. E.g. by this:
COPY (SELECT content FROM d_doc WHERE id = 'x123456') TO
CONCAT('/tmp/mydoc.pdf’) (FORMAT binary);
As we do not have access to the
Works as expected on both ways. Thnx.
-Ursprüngliche Nachricht-
Von: Erik Wienhold
Gesendet: Dienstag, 31. Januar 2023 14:58
An: Marco Lechner ; pgsql-general@lists.postgresql.org
Betreff: Re: Download file from COPY ... TO with pgadmin
> On 31/01/2023 14:02 CET Marco Lechner wr
> On 31/01/2023 14:02 CET Marco Lechner wrote:
>
> Using COPY …TO it is possible to store e.g. the “value” of a bytea cell in a
> directory on the server. E.g. by this:
>
> COPY (SELECT content FROM d_doc WHERE id = 'x123456') TO
> CONCAT('/tmp/mydoc.pdf’) (FORMAT binary);
>
> As we do not have a
Hi,
Using COPY …TO it is possible to store e.g. the “value” of a bytea cell in a
directory on the server. E.g. by this:
COPY (SELECT content FROM d_doc WHERE id = 'x123456') TO
CONCAT('/tmp/mydoc.pdf’) (FORMAT binary);
As we do not have access to the postgresql fileserver (ssh, …), but can SEL
