> 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/ > With Java , Python , Perl you've got functions that escapes the data for you Leonel ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
