Re: Download file from COPY ... TO with pgadmin

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 postgresql fileserver (ssh, …), but can
> SELECT the value of the bytea cell, is It possible to download the bytea
> directly into a file on a client computer when using pgadmin? Is there a
> solution with the COPY … TO command, any pgadmin specific feature or any
> other simple solution?

Read the docs:

https://www.pgadmin.org/docs/pgadmin4/6.19/import_export_data.html

>
> Regards
>
> Marco
>
> i.A. Dr. Marco Lechner
>
> Leiter Fachgebiet RN 1 │ Head RN 1
>
> --

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com