Re: Insert images through ASP

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Dylan Milks" <DMilks(at)greenridge(dot)ca>
Cc: "PostgreSQL (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Insert images through ASP
Date: 2004-07-21 15:31:08
Message-ID: 87oem9cr7n.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Dylan Milks" <DMilks(at)greenridge(dot)ca> writes:

> What I want to do is upload an image from an ASP page and insert it
> into a table. I don't want to store the image on the file system,
> even if it's only temporary.

Well, if you want to use bytea, you'll need to load the whole image
into memory, bytea-encode it, and insert into the table. There's no
way to "stream" a value into a bytea column.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wang, Mary Y 2004-07-21 15:56:51 SQL - display different data
Previous Message Markus Wollny 2004-07-21 15:03:58 Re: tsearch2, ispell, utf-8 and german special characters