Migration from DB2 to PostgreSQL

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general