Re: SQL for multimedia retrieval - Mailing list pgsql-general

Hello,

Yes. Multimedia data can be stored in PostgreSQL database using either bytea
and BLOB types. Depending on size either can be used. BLOB is meant for
storing large data.

Various interfaces are provided to access such data.
Following link can be referred for that.
http://www.postgresql.org/docs/9.1/static/lo-interfaces.htm
<http://www.postgresql.org/docs/9.1/static/lo-interfaces.htm>  l

Or another way to do it is to store the multimedia files in filesystem and
use database to store metadata about them to make them easily accessible.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/SQL-for-multimedia-retrieval-tp5765353p5765396.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.