From: | "Mitch Vincent" <mitch(at)venux(dot)net> |
---|---|
To: | <pgsql-php(at)postgresql(dot)org> |
Subject: | Re: Help with pg_loimport |
Date: | 2001-04-22 18:44:22 |
Message-ID: | 004b01c0cb5c$3fcf8bd0$0200000a@windows |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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(at)bugs(dot)unl(dot)edu(dot)ar>
To: "Richard Whittaker" <richard(at)connections(dot)yk(dot)ca>;
<pgsql-php(at)postgresql(dot)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(at)unl(dot)edu(dot)ar
> Programador, Administrador | Centro de Telematica
> Universidad Nacional
> del Litoral
> -----------------------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Timothy_Maguire | 2001-04-23 15:51:25 | Re: Splitting strings |
Previous Message | Martín Marqués | 2001-04-22 12:31:48 | Re: Help with pg_loimport |