Problem inserting image - Mailing list pgsql-sql

From Tk421
Subject Problem inserting image
Date
Msg-id 494FF3B4.9000201@gmail.com
Whole thread Raw
Responses Re: Problem inserting image  ("Richard Broersma" <richard.broersma@gmail.com>)
List pgsql-sql
    I've made a routine in VB to insert a image into a table. The code is:<br /><br />          <small>Set cmd = New
ADODB.Command<br/>             cmd.ActiveConnection = objconexion<br />             cmd.CommandText = "INSERT INTO
tb_tmp_ventanas(ventana) VALUES (?)"<br />             archivo = "c:\image.jpg"<br />             fd = FreeFile<br />
           Open archivo For Binary Access Read As fd<br />             flen = LOF(fd)<br />             Set imagen =
cmd.CreateParameter("imagen",adLongVarBinary, adParamInput, flen)<br />             ReDim chunk(1 To flen)<br />
           Get fd, , chunk()<br />             imagen.AppendChunk chunk()<br />             cmd.Parameters.Append
imagen<br/>             Set rsInsert = cmd.Execute<br />             Close</small><br />        <br /><br />     But on
executethere is the next error: ERROR: type "lo" does not exist;<br /><br />     How can i reference the "lo" type or
createit, in postgres 8.3<br /><br />     Thank you very much<br /> 

pgsql-sql by date:

Previous
From: Mahmoud Ewiwi
Date:
Subject: Invitation to connect on LinkedIn
Next
From: "Richard Broersma"
Date:
Subject: Re: Problem inserting image