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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
