Re: [GENERAL] Exporting a PDF from a bytea column

2016-02-18 Thread David G. Johnston
On Thu, Feb 18, 2016 at 7:42 PM, CS DBA wrote: > > http://www.postgresql.org/message-id/AANLkTi=2darhqprgtxmcx0aus9mahq2sfxxbvihtu...@mail.gmail.com > > Short answer, to avoid the binary blob problem, is to encode the binary > data, export it, then decode it. > > This can be done is psql. If you

Re: [GENERAL] Exporting a PDF from a bytea column

2016-02-18 Thread CS DBA
On 02/18/2016 07:29 PM, David G. Johnston wrote: On Thursday, February 18, 2016, John R Pierce > wrote: On 2/18/2016 4:44 PM, CS DBA wrote: The system stores PDF's as large objects in bytea columns. Large Objects aka LO's and bytea columns

Re: [GENERAL] Exporting a PDF from a bytea column

2016-02-18 Thread David G. Johnston
On Thursday, February 18, 2016, John R Pierce wrote: > On 2/18/2016 4:44 PM, CS DBA wrote: > >> The system stores PDF's as large objects >> in bytea columns. >> > > Large Objects aka LO's and bytea columns are two completely different > things. > > I'll assume the "column" is the most relevant te

Re: [GENERAL] Exporting a PDF from a bytea column

2016-02-18 Thread John R Pierce
On 2/18/2016 4:44 PM, CS DBA wrote: The system stores PDF's as large objects in bytea columns. Large Objects aka LO's and bytea columns are two completely different things. bytea columns are regular SQL database columns that contain a binary byte array.large objects (LO) are a whole sep

[GENERAL] Exporting a PDF from a bytea column

2016-02-18 Thread CS DBA
Hi all; we have inherited a legacy database. The system stores PDF's as large objects in bytea columns. Can anyone send me an example of exporting from a bytea column to a PDF file? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to yo