storin large objects to postgressql?

[Anon]

Is anybody around who know how i can write large objects to a postgresql database?
The files are insertet via a <input type=file> form. how do i get them into the database?

[Anon]

There is an article on this site about storing binary data in mysql. The same practices apply to postgres.

[Anon]

The prob (kind of) with postgres is that it can only store 8k of data in each row. To get around this you must build a database that will allow you to store each item as multiple rows in 8k chunks.

The best way to store files in a db is to store the files into a directory on your server and then store the path info in plaintext in your db. You then link whatever is reading the file so that it reads the path from the db and then gets the file from the hard disk.

Hope that helps.
-David

[Anon]

This is NOT true for large objects. In fact their implementation was a direct reponse to this problem.

Large objects are automatically split across rows by the db transparently to the user.

If you want a quickie example, look at the postgres section of the official PHP documentation, it shows how to do large object access on postgres from php.