Skip site navigation (1) Skip section navigation (2)

Re: Large Objects

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hunter, Ray" <rhunter(at)enterasys(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Large Objects
Date: 2002-02-28 01:05:52
Message-ID: (view raw or whole thread)
Lists: pgsql-sql
Large ObjectsDon'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.

  -----Original Message-----
  From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Hunter, Ray
  Sent: Wednesday, 27 February 2002 9:46 PM
  To: pgsql-sql(at)postgresql(dot)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...


  Ray Hunter
  Firmware Engineer


  Phone:          801 887-9888
  Fax:            801 972-5789
  Email:          rhunter(at)enterasys(dot)com

In response to


pgsql-sql by date

Next:From: Erle Czar MantosDate: 2002-02-28 02:36:45
Subject: Re: Large Objects
Previous:From: Wei WengDate: 2002-02-27 23:20:22
Subject: Re: How slow is DISTINCT?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group