Hi,

Beeing very impressed by TOAST, I wonder how I can insert BLOB from a flat
file.

It seems quite easy with php; But how can I do it from psql??

TIA

-- 
Olivier PRENANT         	Tel:	+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)


Sun, 28 Jan 2001 20:59:20 +0100
Olivier PRENANT <ohp@pyrenet.fr>
BLOB HOWTO??
El Dom 28 Ene 2001 16:59, Olivier PRENANT escribiï¿½:
>
> Beeing very impressed by TOAST, I wonder how I can insert BLOB from a flat
> file.
>
> It seems quite easy with php; But how can I do it from psql??

I think you mean that it seems easy, because I haven't been able to 
understand it (always talking about the php way).

I can't understand how the pg module of php knows where the large object 
should be inserted. I mean, what if I have 2 large objects in the same 
database (or even in the same table), where is the data inserted? There is no 
place where someone tells php that the data in this variable should go in 
this column that is of type blob.

TIA

-- 
System Administration: It's a dirty job, 
but someone told I had to do it.
-----------------------------------------------------------------
Martï¿½n Marquï¿½s			email: 	martin@math.unl.edu.ar
Santa Fe - Argentina		http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Mon, 29 Jan 2001 09:49:19 -0300
"Martin A. Marques" <martin@math.unl.edu.ar>
Re: BLOB HOWTO??
Maybe the functions lo_import and lo_export is what you're looking for?

regards,
robert gravsjo

Olivier PRENANT wrote:

> Hi,
> 
> Beeing very impressed by TOAST, I wonder how I can insert BLOB from a flat
> file.
> 
> It seems quite easy with php; But how can I do it from psql??
> 
> TIA
> 



Mon, 29 Jan 2001 17:19:21 +0100
robert gravsjo <robert.gravsjo@nsgroup.net>
Re: BLOB HOWTO??