Thread: Migration from DB2 to PostgreSQL

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.

---

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

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



--

-dom

--

IBM - Business Analytics Optimization Consultant
Daniel Mantovani +5511 8538-9897
XOXO

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.
>
>
>