| From: | Pascal Cloup <ptpas059(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | large objects |
| Date: | 2015-06-23 13:33:52 |
| Message-ID: | CA+ubD0jt=bWDUbGUyFsLm9L5zcPkPg5Z0OCaKSRCDOG1Psby_w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi,
Up to now, to store large objects i used the bytea data type. I experienced
this without problem with objects of size of some tens of KBytes, without
specifying any options.
Now, i plan to store much larger objects (tens of MBytes). After reading
the documentation, it seems that i have two options:
- use the option WITH OIDS during CREATE TABLE or ALTER TABLE
or
- use the large objects capabilities supplied by postgreSQL.
Is it a good idea to store such large objects in DB? and if so, what is the
best choice?
I work with postgresSQL 9.4.1, .net and C# under windows.
regards
Pascal
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2015-06-23 16:49:20 | Re: large objects |
| Previous Message | Merlin Moncure | 2015-06-22 12:41:59 | Re: what's wrong with this code? |