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 (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?
-- dave
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
