Thread: Help with pg_loimport

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?...

Thanks muchly in advance,
Richard W.

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
-----------------------------------------------------------------

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" <martin@bugs.unl.edu.ar>
To: "Richard Whittaker" <richard@connections.yk.ca>;
<pgsql-php@postgresql.org>
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
>