Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group