Re: storing PDFs

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Leonel Nunez <lnunez(at)enelserver(dot)com>
Cc: littlebutty <littlebutty(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: storing PDFs
Date: 2006-01-01 16:19:45
Message-ID: 87hd8ndiou.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Leonel Nunez <lnunez(at)enelserver(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leonel Nunez 2006-01-01 16:40:56 Re: storing PDFs
Previous Message Michael Fuhr 2006-01-01 15:53:52 Re: 8.1 removed functions