AI Rumman wrote:
I have an individual text string of 2 GB.
I may use Postgresql 8.4 also. But what data type should I use to
store this column value of 2GB?
GB data objects ni a database is going to make backups, maintenance, etc
a real pain
normal data in postgres can not be over 1GB, so you will need to use the
Larg OBJect facility, where you store an object ID in your actual table,
then store the data via a special Large Object api,
http://www.postgresql.org/docs/current/static/lo-interfaces.html which
can handle up to 2GB max.
quite frankly, i'd as soon store stuff that large as files and and store
their path in the database.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
