Re: [PHP-DB] Insert a xml file into a DB

2008-09-24 Thread Chris
ERNESTO PENALOZA wrote: 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,

Re: [PHP-DB] Insert a xml file into a DB

2008-09-24 Thread Chris
YVES SUCAET 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? guess Postgres provides searching of xml documents using xpath and other such functions:

Re: [PHP-DB] Insert a xml file into a DB

2008-09-23 Thread YVES SUCAET
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 [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Insert a xml file

Re: [PHP-DB] Insert a xml file into a DB

2008-09-23 Thread Matt Anderton
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 [EMAIL PROTECTED]