Received: from sarajevo.idealx.com (sarajevo.idealx.com [213.41.87.90]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0NAr1l79104 for ; Wed, 23 Jan 2002 05:53:02 -0500 (EST) (envelope-from jpargudo@idealx.com) Received: from singer.ird.idealx.com (singer.ird.idealx.com [192.168.0.1]) by sarajevo.idealx.com (8.10.1/8.10.1) with ESMTP id g0NAquY06147 for ; Wed, 23 Jan 2002 11:52:56 +0100 (CET) Received: from pastis (pastis.infra.idealx.com [192.168.1.171]) by singer.ird.idealx.com (8.10.0/8.10.0) with ESMTP id g0NAqoA26984 for ; Wed, 23 Jan 2002 11:52:51 +0100 Received: from jpargudo by pastis with local (Exim 3.33 #1 (Debian)) id 16TKy7-0005Zx-00 for ; Wed, 23 Jan 2002 11:49:27 +0100 Date: Wed, 23 Jan 2002 11:49:27 +0100 From: Jean-Paul ARGUDO To: pgsql-docs@postgresql.org Subject: Large Objects Message-ID: <20020123104927.GA21437@pastis> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.3.25i X-Archive-Number: 200201/26 X-Sequence-Number: 1225 Hi all, I searched to know more about LARGE OBJECTS. Since I come from Oracle world, I first checked section DATATYPES in the admin guide... I read about the CREATE DATATYPE, but I couldn't figure out with this with Large Objects.. I knew that PostgreSQL support long datatypes but I wanted to implement it in my database (got to store images .jpg ...). Searching the doc around and around, I finaly found on developers.postgresql.org the dev projects and TOAST project. I read line « TOAST implemented in 7.1 » !!! Since I am in 7.1.3 I search the doc (nasty grep) about TOAST. I found then all the doc on Large Objects in the Programmer's Guide section « client interfaces » :-) Is this a good place for that? Maybe yes, because thinking about what does the backend to store these oid's... So my request is « Please add a link from DATATYPE pages to theses pages about Large Object ».. Just to let know people like me that Large Objects can be stored in PostgreSQL. Thanks in advance! -- Jean-Paul ARGUDO IDEALX S.A.S Consultant bases de données 15-17, av. de Ségur http://IDEALX.com/ F-75007 PARIS