What are the limits of the TEXT data type in PostgreSQL 6.3.2? I have some
fairly large memos currently in msaccess that I'd like to pull into
postgres (I'm going to convert the entire database into postgres). Some of
our existing memo fields literally have a few pages (ok, generic term, but
translate into the more specific "LOTS") of words. Is there a limit to the
size of TEXT data types? What about searches on this type of field? We
don't need to search our memo fields often, but stranger things have
happened! Thanks for any help!
JT