On Fri, Jun 21, 2013 at 9:40 PM, sachin kotwal <kotsachin@xxxxxxxxx> wrote: >>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? > Sachin, check if this link is related: http://stackoverflow.com/a/10139455/683402 + Here (from official PG docs): http://www.postgresql.org/docs/9.2/static/largeobjects.html -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
