test data type - Mailing list pgsql-general

From JT Kirkpatrick
Subject test data type
Date
Msg-id 01BE4495.546E8E60.jt-kirkpatrick@mpsllc.com
Whole thread Raw
List pgsql-general
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




pgsql-general by date:

Previous
From: JT Kirkpatrick
Date:
Subject: RE: pgsql-general-digest V1 #196
Next
From: James Thompson
Date:
Subject: Oracle vs Postgresql