From: | Erik Wienhold <ewie(at)ewie(dot)name> |
---|---|
To: | Marco Lechner <mlechner(at)bfs(dot)de>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Download file from COPY ... TO with pgadmin |
Date: | 2023-01-31 13:58:08 |
Message-ID: | 264813354.7537.1675173488843@office.mailbox.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2023-01-31 14:02:17 | Re: pgBackrest Error : authentication method 10 not supported |
Previous Message | Daulat | 2023-01-31 13:57:26 | pgBackrest Error : authentication method 10 not supported |