Re: BYTEA vs BLOB - Mailing list pgsql-sql

<div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida
Grande,sans-serif;font-size:13px"><div dir="ltr" id="yui_3_16_0_1_1452841393493_27146">When use Ora2Pg to migrate the
Oracleto Pg, the BLOB data type in Oracle will supposedly be converted into BYTEA in Pg.  Is this achievable?   <br
/></div><divdir="ltr" id="yui_3_16_0_1_1452841393493_27481"><br /></div><div dir="ltr"
id="yui_3_16_0_1_1452841393493_27482">Ifso, after the data become BYTEA, can I further convert the BYTEA into OID data
type,and how to?</div><div dir="ltr" id="yui_3_16_0_1_1452841393493_27501"><br /></div><div dir="ltr"
id="yui_3_16_0_1_1452841393493_27519"><br/></div><div dir="ltr" id="yui_3_16_0_1_1452841393493_27520"><br /></div><div
dir="ltr"id="yui_3_16_0_1_1452841393493_27521">Thanks <br /></div><div dir="ltr"
id="yui_3_16_0_1_1452841393493_27522"><br/></div><div dir="ltr" id="yui_3_16_0_1_1452841393493_27523">Eugene<br
/></div><divid="yui_3_16_0_1_1452841393493_26693"><span></span></div><div class="qtdSeparateBR"><br /><br /></div><div
class="yahoo_quoted"style="display: block;"><div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial,
LucidaGrande, sans-serif; font-size: 13px;"><div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial,
LucidaGrande, sans-serif; font-size: 16px;"><div dir="ltr"><font face="Arial" size="2"> On Thursday, January 14, 2016
8:05AM, John DeSoi <desoi@pgedit.com> wrote:<br /></font></div><br /><br /><div class="y_msg_container"><div
class="yqt2845761187"id="yqtfd14951"><br clear="none" />> On Jan 12, 2016, at 7:45 PM, Eugene Yin <<a
href="mailto:eugeneymail@ymail.com"shape="rect" ymailto="mailto:eugeneymail@ymail.com">eugeneymail@ymail.com</a>>
wrote:<brclear="none" />> <br clear="none" />> Now if I migrate the Oracle table to Postgres and change the data
typeto BYTEA, how will the photo file (BYTEA) be stored?<br clear="none" />> <br clear="none" />> 1) The whole
photodata will be stored inside the table?<br clear="none" />> <br clear="none" />> Or<br clear="none" />> <br
clear="none"/>> 2) Only the reference to the data is stored inside the table, the data itself will be stored outside
thetable (but still within the database) for efficiency purpose?</div><br clear="none" />> <br clear="none" /><br
clear="none"/>This is a good summary of your options:<br clear="none" /><br clear="none" /><a
href="https://www.microolap.com/products/connectivity/postgresdac/help/tipsandtricks_byteavsoid.htm"shape="rect"
target="_blank">https://www.microolap.com/products/connectivity/postgresdac/help/tipsandtricks_byteavsoid.htm</a><br
clear="none"/><br clear="none" />John DeSoi, Ph.D.<br clear="none" /><br clear="none" /><br clear="none" /><br
clear="none"/>-- <br clear="none" />Sent via pgsql-sql mailing list (<a href="mailto:pgsql-sql@postgresql.org"
shape="rect"ymailto="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br clear="none" />To make changes
toyour subscription:<br clear="none" /><a href="http://www.postgresql.org/mailpref/pgsql-sql" shape="rect"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/><br /></div></div></div></div></div>