X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C66AF52834 for ; Tue, 7 Jun 2005 03:41:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37247-08 for ; Tue, 7 Jun 2005 06:41:22 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.205]) by svr1.postgresql.org (Postfix) with ESMTP id AFE7A52856 for ; Tue, 7 Jun 2005 03:41:21 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 69so102540wra for ; Mon, 06 Jun 2005 23:41:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=cOuwijQeMegxuEDPl+z6Oku2rELN5JH0kJNYEPeo1cT8/XUDpRbwnTLQDroLW320Dkiv3OwFjZfNc4rxVr5cOpNsQAGAs2pXyfgoFxZcO+qlBorV0KLN5DvtrkmOhZ3KuXhImlph6mUS6eER+rdiX6eD9atsXENBQG98JQp4UDc= Received: by 10.54.123.10 with SMTP id v10mr1499748wrc; Mon, 06 Jun 2005 23:41:22 -0700 (PDT) Received: by 10.54.30.45 with HTTP; Mon, 6 Jun 2005 23:41:22 -0700 (PDT) Message-ID: <7104a737050606234156b4eced@mail.gmail.com> Date: Tue, 7 Jun 2005 09:41:22 +0300 From: Volkan YAZICI Reply-To: Volkan YAZICI To: Vadivel Subramaniam Subject: Re: large object support in PostGres 7.4 Cc: pgsql-sql In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.149 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200506/95 X-Sequence-Number: 21696 Hi, On 6/7/05, Vadivel Subramaniam wrote: > My doubt is, do these API's operate on character data? i.e., My table > schema is like this >=20 > table (name varchar, script varchar). I have to store a large data(in > character form) in the script column (upto 3 MB). >=20 > As of my understanding the above mentioned API's work on the OID field. > i.e,. table(name varchar, script oid). Is that correct? Yep. Large Objects are stored (and distributed between rows) in a specific table: `pg_largeobject'. You can use these lo records by referencing to their OIDs. Furthermore, you cannot (also shouldn't) reach data on pg_largeobject with another function/routine out of supplied lo_... functions by libpq. > Please clarify this if anyone has already used this large object APIs and > specify if this has any limitation on the size? Yes, there's a limitation about 'em. (2GB) For more information please see:= =20 http://www.postgresql.org/docs/7.4/interactive/largeobjects.html Regards.