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

Works as expected on both ways. Thnx.

-----Ursprüngliche Nachricht-----
Von: Erik Wienhold <ewie(at)ewie(dot)name>
Gesendet: Dienstag, 31. Januar 2023 14:58
An: Marco Lechner <mlechner(at)bfs(dot)de>; pgsql-general(at)lists(dot)postgresql(dot)org
Betreff: Re: Download file from COPY ... TO with pgadmin

> On 31/01/2023 14:02 CET Marco Lechner <mlechner(at)bfs(dot)de> 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 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?

Use psql with \copy which targets the client file system. pgAdmin 5.4+ can also launch psql.

--
Erik