Received: from mail3.mx.voyager.net (mail3.mx.voyager.net [216.93.66.202]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3MIkm349640 for ; Sun, 22 Apr 2001 14:46:49 -0400 (EDT) (envelope-from mitch@venux.net) Received: from windows (mdmmi052194.voyager.net [216.93.52.194]) by mail3.mx.voyager.net (8.10.2/8.10.2) with SMTP id f3MIkke73970 for ; Sun, 22 Apr 2001 14:46:46 -0400 (EDT) Message-ID: <004b01c0cb5c$3fcf8bd0$0200000a@windows> From: "Mitch Vincent" To: References: <5.0.1.4.0.20010421150754.04f23640@excalibur.connections.yk.ca> <01042215314801.15755@bugs> Subject: Re: Help with pg_loimport Date: Sun, 22 Apr 2001 14:44:22 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200104/25 X-Sequence-Number: 278 Is it not as straight forward as it looks? I've never used large objects in PostgreSQL so I really don't know.. From the PHP manual : >int pg_loimport (int file [, int connection_id]) >The filename argument specifies the pathname of the file to be imported as a large object. Returns FALSE if an error occurred, object id of the just created >large object otherwise. Remember that handling large objects in PostgreSQL must happen inside a transaction. Looks like file there is a file descriptor returned by fopen() [?] and the connection ID is that of the PostgreSQL connection.. What happens when you try it? -Mitch ----- Original Message ----- From: "Martín Marqués" To: "Richard Whittaker" ; Sent: Sunday, April 22, 2001 8:31 AM Subject: Re: [PHP] Help with pg_loimport > On Dom 22 Abr 2001 01:09, Richard Whittaker wrote: > > I posted this orignally on phpbuilder.net, but I also wanted to try here as > > well... > > > > Thanks kindly! > > Richard. > > > > Author: Richard Whittaker (199.247.236.117) > > Date: 2001-04-21 16:15:13 > > > > Greetings: > > > > Does anyone have any examples of using the pg_loimport routines in PHP?... > > > > I have a requirement to be able to import a binary file (an image) into a > > table that has three columns. > > > > The first two columns are sequence integers, and the third is an OID > > column. I would like to be able, via my PHP script, to insert a new image, > > with the two integers, but I don't see any examples of this for PostGres > > and PHP... Is this possible to do at all?... > > Oh please! If someone has a small example of how to do this, I think lots of > use will be gratefull!!!!! > > Saludos... :-) > > P.D.: I have send this question before, with no answer. > > -- > El mejor sistema operativo es aquel que te da de comer. > Cuida tu dieta. > ----------------------------------------------------------------- > Martin Marques | mmarques@unl.edu.ar > Programador, Administrador | Centro de Telematica > Universidad Nacional > del Litoral > ----------------------------------------------------------------- > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >