> On Jan 12, 2016, at 7:45 PM, Eugene Yin <eugeneymail@ymail.com> wrote:
>
> Now if I migrate the Oracle table to Postgres and change the data type to BYTEA, how will the photo file (BYTEA) be
stored?
>
> 1) The whole photo data will be stored inside the table?
>
> Or
>
> 2) Only the reference to the data is stored inside the table, the data itself will be stored outside the table (but
stillwithin the database) for efficiency purpose?
>
This is a good summary of your options:
https://www.microolap.com/products/connectivity/postgresdac/help/tipsandtricks_byteavsoid.htm
John DeSoi, Ph.D.
