Re: storing PDFs - Mailing list pgsql-general

From Doug McNaught
Subject Re: storing PDFs
Date
Msg-id 87hd8ndiou.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: storing PDFs  (Leonel Nunez <lnunez@enelserver.com>)
Responses Re: storing PDFs
List pgsql-general
Leonel Nunez <lnunez@enelserver.com> writes:

> You can   use ByteA   but the size will be  about 4 times bigger

Are you sure?  The intermediate form for bytea (escaped single-quoted
strings) is pretty inefficient, but once in the database the data is
stored as binary and can even be compressed.

Plus, I'm pretty sure the protocol supports transmitting bytea fields
as binary over the wire if your client software can handle it.

-Doug

pgsql-general by date:

Previous
From: Leonel Nunez
Date:
Subject: Re: storing PDFs
Next
From: Leonel Nunez
Date:
Subject: Re: storing PDFs