Re: Inserting into the blob - Mailing list pgsql-general

From Igor Korot
Subject Re: Inserting into the blob
Date
Msg-id CA+FnnTwUhTdovmEJgVK4LTX8QzeYsHk=-kchJoh6PNq-FaAnPQ@mail.gmail.com
Whole thread Raw
In response to Re: Inserting into the blob  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Inserting into the blob
List pgsql-general
Hi, Adrian,

On Mon, Jun 10, 2019 at 7:03 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 6/10/19 9:30 AM, Igor Korot wrote:
>
> >
> > According to
https://stackoverflow.com/questions/16048649/postgresql-9-x-pg-read-binary-file-inserting-files-into-bytea,
> > the file needs to be on the server inside PGDATA directory.
> > It is not a problem in general, but just curious - is there a more
> > generic solution (to get the file from the client)?
>
> This would depend on what is is you are trying to accomplish:
>
> 1) Are you really wanting to insert a file at a time at the psql command
> line?

Yes.

>
> 2) If not then is there a program you are using/writing that will insert
> the data?

More like the program will query for the data...

Thank you.

>
> >
> > Thank you.
> >
>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Upgrade from PostgreSQL 9.6 to 11
Next
From: Adrian Klaver
Date:
Subject: Re: Inserting into the blob