Thread: Migration from DB2 to PostgreSQL

While migrating my application from DB2 to PostgreSQL.

I want to migrate following functions in PostgreSQL.

Functions in DB2: BLOB()/CLOB()

Criteria:
Size of character string targeted for cast is more than 1GB.  Character
String as argument to this function.

How can I migrate this function into PostgreSQL with above mention criteria.



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

Am 19.06.2013 08:05, schrieb sachin kotwal:

While migrating my application from DB2 to PostgreSQL.

I want to migrate following functions in PostgreSQL.

Functions in DB2: BLOB()/CLOB() 

Criteria: 
Size of character string targeted for cast is more than 1GB.  Character
String as argument to this function.

How can I migrate this function into PostgreSQL with above mention criteria.

Hi,

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

Thomas

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

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