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

From Joshua D. Drake
Subject Re: Migration from DB2 to PostgreSQL
Date
Msg-id 51C4F974.6000809@commandprompt.com
Whole thread Raw
In response to Re: Migration from DB2 to PostgreSQL  (Daniel de Oliveira Mantovani <daniel.oliveira.mantovani@gmail.com>)
List 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@gmail.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.
>
>
>



pgsql-general by date:

Previous
From: Daniel de Oliveira Mantovani
Date:
Subject: Re: Migration from DB2 to PostgreSQL
Next
From: Xiaobo Gu
Date:
Subject: File size consideration of file_fdw in PostgreSQL