Monday, January 25, 2010

To Store file in postgres database

There are two methods to store a file in database.

1. use either bytea type of database (Stores file as bytestream <1 GB)

2. use large objects type ( stores file in separate table referenced by integer OID)


for more information see the following links

http://www.postgresql.org/docs/7.4/interactive/jdbc-binary-data.html#JDBC-BINARY-DATA-EXAMPLE