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,
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:
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
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]