Postgres Pro
Downloads
Home   >   mailing lists

Re: Large Objects - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: Large Objects
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEJDCBAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Large Objects  ("Hunter, Ray" <rhunter@enterasys.com>)
Responses Re: Large Objects  (Alexander Steinert <stony8@gmx.de>)
List pgsql-sql
Tree view
Don't use them.  They were needed when Postgres only supported 8k per row.  Now you can just use the 'text' datatype for text data and the 'bytea' datatype for binary data.  You have a limit of a few gigs per row with them.
 
Chris
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Hunter, Ray
Sent: Wednesday, 27 February 2002 9:46 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] Large Objects

I have been reading the user manual for largre objects in postgres.  What I do not understand is when and why you would use them?

Can someone point me to some good documentation on this...

Thanks,

Ray Hunter
Firmware Engineer

ENTERASYS NETWORKS

Phone:          801 887-9888
Fax:            801 972-5789
Email:          rhunter@enterasys.com
www:            www.enterasys.com

pgsql-sql by date:

Previous
From: Erle Czar Mantos
Date:
Subject: Re: Large Objects
Next
From: "Jan Oravec"
Date:
Subject: backward SQL query