Re: Migration from DB2 to PostgreSQL

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Daniel de Oliveira Mantovani <daniel(dot)oliveira(dot)mantovani(at)gmail(dot)com>
Cc: sachin kotwal <kotsachin(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Migration from DB2 to PostgreSQL
Date: 2013-06-22 01:10:12
Message-ID: 51C4F974.6000809@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 06/21/2013 04:49 PM, Daniel de Oliveira Mantovani wrote:
>
> http://wiki.postgresql.org/images/d/d1/DB2UDB-to-PG.pdf
>
> On 18 June 2013 05:52, sachin kotwal <kotsachin(at)gmail(dot)com> wrote:
>> Function in DB2: BLOB() Criteria: Size of character string targeted for cast
>> is more than 1GB How can I migrate this function into PostgreSQL with above
>> mention criteria.

The TEXT data type within PostgreSQL has a limit 1GB. You may want to
consider using large objects or breaking up your text to more reasonable
values per row.

JD

>> ________________________________
>> View this message in context: Migration from DB2 to PostgreSQL
>> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Xiaobo Gu 2013-06-22 12:06:44 File size consideration of file_fdw in PostgreSQL
Previous Message Daniel de Oliveira Mantovani 2013-06-21 23:49:39 Re: Migration from DB2 to PostgreSQL