I'm with Yves -- just store the xml files on the local disk and then record their *location* in the DB if you need to reference them. if you really want to store the xml in the db, why not just use a 'text' data type? -- matt On Tue, Sep 23, 2008 at 4:35 PM, YVES SUCAET <yves.sucaet@xxxxxxx> wrote: > Why do you need to store the files in a database? Can't you just keep them > on > the hard disk and query them with DOM? > > > ------ Original Message ------ > Received: Tue, 23 Sep 2008 03:55:25 PM CDT > From: ERNESTO PENALOZA <penalozae@xxxxxxxxx> > To: php-db@xxxxxxxxxxxxx > Subject: Insert a xml file into a DB > > Hi there, I've been trying to insert (and retrieve) a xml file into a > postgres DB into a BLOB field, using some nice examples downloaded from the > net, but they don't seem to work. Is there a "standard" way to do this? > > I read about a bytea data type and run some examples, but never understood > how this data type works. When I retrieve the data, all I could see was a > number. What should I do with this number? How can I use it to see the xml > file content.? > > Thank you in advance. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
