Re: [GENERAL] capacity of datatype text

2004-10-19 Thread John DeSoi
On Oct 19, 2004, at 1:14 AM, David Garamond wrote: btw, TEXT is one of those postgres-specific features that makes you stick (stuck? :-) with postgres. nowadays, i never ever have to bother to think whether to give a column a max width of 32, 50, 64, 100, 150, ... is that a bad thing I don't

[GENERAL] capacity of datatype text

2004-10-18 Thread John Ossmann
I'm not sure where to find it exactly, but does anyone know how much data a column of type text in a postgres DB can hold? Thanks ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [GENERAL] capacity of datatype text

2004-10-18 Thread Neil Conway
On Wed, 2004-10-13 at 14:58, John Ossmann wrote: I'm not sure where to find it exactly, but does anyone know how much data a column of type text in a postgres DB can hold? There is no limit on what text itself can contain. However, a field of any data type can contain at most 1GB (compressed --

Re: [GENERAL] capacity of datatype text

2004-10-18 Thread David Garamond
John Ossmann wrote: I'm not sure where to find it exactly, but does anyone know how much data a column of type text in a postgres DB can hold? it's in the manual, in the Data Types section. the manual says around 1GB. btw, TEXT is one of those postgres-specific features that makes you stick