Search Postgresql Archives

Re: storing PDFs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Leonel Nunez <lnunez@xxxxxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux