Re: Using TEXT columns for binary content - Mailing list pgsql-general

From Lamar Owen
Subject Re: Using TEXT columns for binary content
Date
Msg-id 200304211218.57267.lamar.owen@wgcr.org
Whole thread Raw
In response to Re: Using TEXT columns for binary content  (Joe Conway <mail@joeconway.com>)
List pgsql-general
On Monday 21 April 2003 12:01, Joe Conway wrote:
> Mircea Sarbu wrote:
> > There are some hidden drawbacks for this approach? (I don't need any
> > further processing on the binary content)

> There are people who have reported using this method successfully on the
> Postgres lists. Only downsides I can think of are:

> 1) You have to encode to base64 on the way in (bytea has to be escaped
>     on INSERT/UPDATE too)

OpenACS uses this technique.  The PostgreSQL driver for AOLserver (which
OpenACS uses) has code -- aolserver.sourceforge.net -- files, nspostgres.
GPL/APL dual-licensed, if that matters.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11


pgsql-general by date:

Previous
From: Murthy Kambhampaty
Date:
Subject: Re: stddev returns 0 when there is one row
Next
From: Tom Lane
Date:
Subject: Re: stddev returns 0 when there is one row