From: Mitch Vincent <mitch@venux.net>
To: pgsql-php@postgresql.org
Subject: Re: Help with pg_loimport
Date: Sun, 22 Apr 2001 14:44:22 -0400
Message-ID: <004b01c0cb5c$3fcf8bd0$0200000a@windows> (raw)
References: <5.0.1.4.0.20010421150754.04f23640@excalibur.connections.yk.ca>
<01042215314801.15755@bugs>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: mitch@venux.net
Subject: Re: Help with pg_loimport
In-Reply-To: <004b01c0cb5c$3fcf8bd0$0200000a@windows>
References: <5.0.1.4.0.20010421150754.04f23640@excalibur.connections.yk.ca> <01042215314801.15755@bugs> <004b01c0cb5c$3fcf8bd0$0200000a@windows>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox