Re: Insert images through ASP - Mailing list pgsql-general

From Doug McNaught
Subject Re: Insert images through ASP
Date
Msg-id 87oem9cr7n.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: Insert images through ASP  ("Dylan Milks" <DMilks@greenridge.ca>)
List pgsql-general
"Dylan Milks" <DMilks@greenridge.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

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: tsearch2, ispell, utf-8 and german special characters
Next
From: "Wang, Mary Y"
Date:
Subject: SQL - display different data