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)
Any help is appreciated.
Thanks