From: | Sharmila Jothirajah <sharmi_jo(at)yahoo(dot)com> |
---|---|
To: | General postgres mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Manipulating Large Object datatype in Postgresql |
Date: | 2010-02-08 19:27:15 |
Message-ID: | 841070.4468.qm@web110701.mail.gq1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
We have tables with data type CLOb and BLOBs (in oracle). This needs o be migrated to Postgresql. What data types can be used for this. I've done some resaerch/search in this and found that (correct me if Im wrong)
1. For CLObs the equivalent are TEXT and OID(lob).
But streaming(thro' jdbc) is possible only with oids
2. For Blobs the equivalent are oid(lob) and bytea (again straeming is possible only with oid)
Questions:
1. Which is the better approach for CLOb/BLOB? I need straeming possible since the data are pretty big
2. How is UPDATE/DELETE handled with the lob datatype?
Would it update the referenced data? Or would it create a new lob
and update the pointer, keeping the old data somewhere? Or would that
depend on our implementation? Would it make a difference if the new value
was null?
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Vincenzo Romano | 2010-02-08 19:33:35 | R: One column to multiple columns based on constraints? |
Previous Message | Ivan Sergio Borgonovo | 2010-02-08 19:14:41 | turning a tsvector without position in a weighted tsvector |