Selecting Large Object and TOAST

From: vishal saberwal <vishalsaberwal(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Selecting Large Object and TOAST
Date: 2005-12-05 00:55:47
Message-ID: 3e74dc250512041655u6a5742cew4429db7639715a41@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

We are storing the Icons/IMages in the database as Large Objects using
lo_import functions.

(1) what would be the return type if i want to return a large object (
XYZ.gif) to the remote client (GUI) using stored procedure.
Can anyone give an example please?
Are there any size limitations i need to consider when returning Large
Object using procedures?

(2) A statement from documentation:
"PostgreSQL 7.1 introduced a mechanism (nicknamed "TOAST") that allows data
values to be much larger than single pages. This makes the large object
facility partially obsolete."
How do i TOAST my data stored as Large Object?

thanks,
vish

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2005-12-05 01:04:32 Re: Slow COUNT
Previous Message Havasvölgyi Ottó 2005-12-05 00:37:44 Creating then dropping primary key constraint