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