Re: loading a file into a field

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