Storing images as BYTEA or large objects
От | Koen Vermeer |
---|---|
Тема | Storing images as BYTEA or large objects |
Дата | |
Msg-id | 1202856075.3528.61.camel@localhost обсуждение исходный текст |
Ответы |
Re: Storing images as BYTEA or large objects
Re: Storing images as BYTEA or large objects Re: Storing images as BYTEA or large objects Re: Storing images as BYTEA or large objects |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: