Re: PDF files: to store in database or not - Mailing list pgsql-general

From Rich Shepard
Subject Re: PDF files: to store in database or not
Date
Msg-id alpine.LNX.2.11.1612061207160.31587@localhost
Whole thread Raw
In response to Re: PDF files: to store in database or not  (David Wall <d.wall@computer.org>)
Responses Re: PDF files: to store in database or not
List pgsql-general
On Tue, 6 Dec 2016, David Wall wrote:

> The advantages of storing in the database is that a DB backup will have
> everything, instead of a DB backup and a file system backup. Using a BLOB,
> you can certainly keep track of variable length PDFs.

David,

   I did not realize that a BLOB is not the same as a bytea (page 217 of the
9.6 PDF manual), and I cannot find BLOB as a postgres data type. Please
point me in the right direction to learn how to store PDFs as BLOBs.

Thanks,

Rich


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PDF files: to store in database or not
Next
From: Tom Lane
Date:
Subject: Re: Select works only when connected from login postgres