| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Eugene Yin <eugeneymail(at)ymail(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: BYTEA vs BLOB |
| Date: | 2016-01-14 16:00:49 |
| Message-ID: | 3E62E3B0-473E-4251-AD96-64D57E5C5186@pgedit.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> On Jan 12, 2016, at 7:45 PM, Eugene Yin <eugeneymail(at)ymail(dot)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 still within 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Moore | 2016-01-15 20:24:35 | remove null values from json |
| Previous Message | Adrian Klaver | 2016-01-13 17:48:13 | Re: best way sync data from Oracle to PostgreSQL? |