From: Tim Landscheidt <tim@tim-landscheidt.de>
To: pgsql-sql@postgresql.org
Subject: Re: loading a file into a field
Date: Thu, 31 Dec 2009 18:15:28 +0000
Message-ID: <m3eimbm2m7.fsf@passepartout.tim-landscheidt.de> (raw)
References: <df8d2df50912310823p1d2e3fdu6496571484360be1@mail.gmail.com>
Brian Sherwood <bdsher@gmail.com> wrote:
> I am looking to play around with the postgres XML functions, but can't
> seem to find a way to load my data.
> I have a number of XML files: file1.xml, file2.xml, etc.... All files
> follow the same xml format (DTD?)
> I would like to create the following table:
> CREATE TABLE configs (
> filename varchar(80) PRIMARY KEY,
> config xml
> );
> and load each file into the xml field, but can't seem to find a way.
> (I think I need something similiar to lo_import, but have not found anything)
There is no function to do that in the standard distribu-
tion. You have to solve that in your client application.
Theoretically, you could try to do it in a server-side user
function, but permissions, local vs. remote file systems &
Co. usually only create major headaches.
Tim
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tim@tim-landscheidt.de
Subject: Re: loading a file into a field
In-Reply-To: <m3eimbm2m7.fsf@passepartout.tim-landscheidt.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox