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@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Koen Vermeer > Sent: Tuesday, February 12, 2008 11:41 PM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: 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/ > ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
