Re: Storing images as BYTEA or large objects
От | Gevik Babakhani |
---|---|
Тема | Re: Storing images as BYTEA or large objects |
Дата | |
Msg-id | 001e01c86e0a$f988f590$0a01a8c0@gevmus обсуждение исходный текст |
Ответ на | Storing images as BYTEA or large objects (Koen Vermeer <koen@vermeer.tv>) |
Ответы |
Re: Storing images as BYTEA or large objects
|
Список | pgsql-general |
Hi, Which programming language are you using? Regards, Gevik Babakhani ------------------------------------------------ PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl ------------------------------------------------ > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Koen Vermeer > Sent: Tuesday, February 12, 2008 11:41 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Storing images as BYTEA or large objects > > Hi, > > I would like to store binary data in a PostgreSQL database. > The size of the data is about 2 to 20 MB and is always stored > or retrieved as a block (i.e., I do not need to get only part > of the data). As I understand, I have two options for storing > this data: As BYTEA or as large objects. As I understand, the > disadvantage of the first method is that I need to write a > custom routine to escape some binary values - or is there > some code available to do this? The disadvantage of large > objects is their existence outside of the main database, > which may be problematic when backing up a database. In > addition, I need special routines to store/retrieve the data. > > My two questions are: Is this summary correct? And: Which > method should I choose? > > Best, > Koen > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ >
В списке pgsql-general по дате отправления: