Re: BLOBS in DB and MDB

<M.Kaening@osram.de> wrote : > Hi Jeroen, > >> How do people store their binary data (pdf's, word docs etc) in >> Postgres? I noticed you can store it in a TEXT field (up to 1GB IIRC), >> but also using OID's. Which techniques do MDN/DB use? > as far as I know it is recommended never to store binary data like this > directly in a database, instead rather store there location in a file > system. This speeds everything up dramatically and is safer, assuming the > file system is held consistent with the DB. AFAIK, that's wrong with Oracle at least. You can store BLOB in database without speed or security loss. It is even recommended, if you use Oracle Text to index your files. I don't know about PostgreSQL behaviour. Bertrand Mansion Mamasam