On Tue, Feb 9, 2010 at 11:26 PM, Steve Atkins <st...@blighty.com> wrote: > > On Feb 9, 2010, at 9:52 PM, Scott Marlowe wrote: > >> On Tue, Feb 9, 2010 at 9:38 PM, AI Rumman <rumman...@gmail.com> wrote: >>> How to save 2 GB or more text string in Postgresql? >>> Which data type should I use? >> >> If you have to you can use either the lo interface, or you can use >> bytea. Large Object (i.e. lo) allows for access much like fopen / >> fseek etc in C, but the actual data are not stored in a row with >> other data, but alone in the lo space. Bytea is a legit type that you >> can have as one of many in a row, but you retrieve the whole thing at >> once when you get the row. > > Bytea definitely won't handle more than 1 GB. I don't think the lo interface > will handle more than 2GB.
That really depends on how compressible it is, doesn't it? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
