>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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
