Re: Migration from DB2 to PostgreSQL

Thomas Markus <t.markus@xxxxxxxxxxxxx> · Wed, 19 Jun 2013 08:29:16 +0200

    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