Re: Inserting into the blob

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?

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

> 
> Thank you.
> 



-- 
Adrian Klaver
adrian.klaver@aklaver.com