RE: Re: Storing images in PG?

From: "Andrew SNow" <andrew(at)modulus(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: RE: Re: Storing images in PG?
Date: 2001-08-16 08:52:32
Message-ID: 000001c12630$c9ab7fb0$fa01b5ca@avon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Yes, but good is encode binary data (image) to same ascii safe
> encoding like base64, else you will have problem in INSERT/UPDATE
> queries.

Correct me if I'm wrong, but the only thing "lztext" can't store is
NULLs, which could escaped somehow with other (rare) characters. Still
overhead, but you shouldn't be storing large pieces of binary data this
way, I think.

- Andrew

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karel Zak 2001-08-16 09:17:28 Re: Re: Storing images in PG?
Previous Message Tod McQuillin 2001-08-16 08:41:25 Re: Re: Storing images in PG?