Re: Migration from DB2 to PostgreSQL - Mailing list pgsql-general

Am 19.06.2013 08:05, schrieb sachin kotwal:

While migrating my application from DB2 to PostgreSQL.

I want to migrate following functions in PostgreSQL.

Functions in DB2: BLOB()/CLOB() 

Criteria: 
Size of character string targeted for cast is more than 1GB.  Character
String as argument to this function.

How can I migrate this function into PostgreSQL with above mention criteria.

Hi,

as i know each value is limited to 1GB. For larger content use module lo
http://www.postgresql.org/docs/9.2/static/lo.html

Thomas