On Thu, 2005-08-04 at 10:57, Benjamin Scherrey wrote: > In Postgres 8, if a row attribute is defined as 'character varying' > without specifying a size, what is its size limit? Is it a > platform-specific/char encoding issue? Is this the same as declaring it > a 'text' type? I don't find this specified in the documentation. Approx 1 gig (2^30). The highest limit you can SET if you choose to do so it 2^20 (1 meg). text and varchar are the same type, inside, by the way. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly