Roberto Mello said: > Are you sure PG has a decode function? I don't recall one. Yes, but very different from Oracle's! http://www.postgresql.org/docs/7.4/static/functions-binarystring.html
> The way I've seen BLOBs in PostgreSQL was either using PG's lo_* Oh, I use a bytea column, which seems to be the recommended (ie: properly documented) type. > One problem is that your backups can get really huge. You, thought about that. But I decided to have one central store anyway. This is just for people's mugshots and they also get copied out to the pageroot. Filesize is <10K, so even with 100.000 users in the system you are still looking at 100Mb, which I can easily live with. (although with the escaping "dump" does on it, you probably end up with a 300Mb dump file) The idea is that when the system does hit a substantial number of users and requires multiple webservers, they can be copied out from the database to all servers. Bas. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
