Struggling with PG SQL and Large Objects
| From: | eric dot jones at hua dot army dot mil | Date: | Wed, 24 Jul 2002 18:08:33 +0000 |
| Subject: | Struggling with PG SQL and Large Objects | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20746@lists.php.net to get a copy of this message | ||
CLASSIFICATION: UNCLASSIFIED
I'm creating a script to upload documents (word, PDF, text, ppt, etc files)
to a PG 7.2 DB.
I currently can upload the file using pg_lo_import. I get back my OID which
I store in a separate table and I can remove the files using the unlink
command.
However for the life of me I cannot get the file to be downloaded from a
person's browsers. I keep getting an error that the file cannot be found.
Does anyone have an example or working script of how to download a file that
has been pg_lo_imported? I do not want to export the file unless I HAVE to..
Looking forward to your guidance!
Eric Jones (Contractor)
FDIC Web Enabler
E-mail: jonese@hua.army.mil
Office - 520-533-6628
Cell - 520-980-2136
Email Pager - 5209802136@messaging.nextel.com
Direct Private Fax - 866-721-4102