Re: Migration from DB2 to PostgreSQL

>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


I just want to know that like DB2 we can convert other data types into
CLOB/BLOB using function CLOB()/BLOB().

Example:
SELECT CLOB('testdata') FROM SYSIBM.SYSDUMMY1

Same way i want to convert other data types into large objects Oid in
PostgreSQL.

Proposed SQL will like:

select col1::oid from hoge;

------OR------

select to_oid('testdata');

Can anyone tell me that how I can implement above function for conversion?




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Migration-from-DB2-to-PostgreSQL-tp5759800p5760319.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.