Re: Display large object from database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: greg(at)officium(dot)co(dot)za
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Display large object from database
Date: 2006-06-05 18:00:39
Message-ID: 21743.1149530439@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<greg(at)officium(dot)co(dot)za> writes:
> Thanks, I read the pgAdmin help on a bytea column, but it doesn't specify its maximum size. What is
> the largest filesize I can fit into a bytea column?

The hard limit is 1Gb. Practical limit is probably a good deal less,
depending on your machine, but I don't know of anyone who's tried to
measure performance with such wide column values.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Moravec Jan 2006-06-06 00:05:02 Inserting file content into column
Previous Message greg 2006-06-05 17:11:33 Re: Display large object from database