On Fri, Jun 21, 2013 at 9:40 PM, sachin kotwal <kotsachin@gmail.com> 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