bytea was what I was going for.
Does anyone have a script they would share for this purpose?
If not I will probably use Java because this is what I am familiar with.
The web app I will write for managing my photos will be written in Java. I want to be able to categorize, label, search,.... my photos.
Alan Hodgson wrote:
On Tuesday 13 January 2009, Jason Long <mailing.list@supernovasoftware.com>
wrote:
I would like to use PSQLFS(http://www.edlsystems.com/psqlfs/)
to store 100 GB of images in PostgreSQL.
Once they are in there I can deal with them. My main purpose is to use
rsync to get the files into the database.
Is there a better way to load 20,000 plus files reliably into Postgres?
A perl script using either bytea fields or the lo_ interface via DBD::Pg
would work well.