From: | Tim Landscheidt <tim(at)tim-landscheidt(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: loading a file into a field |
Date: | 2009-12-31 18:15:28 |
Message-ID: | m3eimbm2m7.fsf@passepartout.tim-landscheidt.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Brian Sherwood <bdsher(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Gould | 2009-12-31 18:17:26 | Re: Proper case function |
Previous Message | Gary Chambers | 2009-12-31 17:40:35 | Re: Proper case function |