> On Jun 10, 2019, at 6:40 AM, Igor Korot <ikorot01@xxxxxxxxx> wrote: > > Hi, Adrian, > >> On Mon, Jun 10, 2019 at 7:03 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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. Gnarly. I suppose you could open the pdf in emacs and tell emacs to NOT render it. Cut the entire buffer and paste it, properly quoted, into your psql command line. But \lo stuff seems much more likely to work. > >> >> 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@xxxxxxxxxxx > >
