Brian Sherwood <bds...@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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
