Postgres Pro
Downloads
Home   >   mailing lists

Re: Display large object from database - Mailing list pgsql-novice

From Tom Lane
Subject Re: Display large object from database
Date
Msg-id 21743.1149530439@sss.pgh.pa.us
Whole thread Raw
In response to Re: Display large object from database  (<greg@officium.co.za>)
List pgsql-novice
Tree view 
<greg@officium.co.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

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: Display large object from database
Next
From: "Moravec Jan"
Date:
Subject: Inserting file content into column