Re: Problem inserting image

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: Tk421 <vrobador(at)gmail(dot)com>
Cc: "sql pgsql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problem inserting image
Date: 2008-12-22 20:33:11
Message-ID: 396486430812221233y25aa24s69197c507ae36ec7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Dec 22, 2008 at 12:08 PM, Tk421 <vrobador(at)gmail(dot)com> wrote:

> I've made a routine in VB to insert a image into a table. The code is:
> But on execute there is the next error: ERROR: type "lo" does not exist;
>
> How can i reference the "lo" type or create it, in postgres 8.3

Here is an example how how ADODB.Stream class work in conjunction with
ADODB.command prepared statements to push binary data into a field.
The same should work with PostgreSQL.

http://www.databasedevelopment.co.uk/examples/StoredBlobs.zip

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Venkat Rao Tammineni 2008-12-24 07:06:47 How to Import Excel Into PostgreSQL database
Previous Message Tk421 2008-12-22 20:08:20 Problem inserting image