loading a file into a field - Mailing list pgsql-sql

From Brian Sherwood
Subject loading a file into a field
Date
Msg-id df8d2df50912310823p1d2e3fdu6496571484360be1@mail.gmail.com
Whole thread Raw
Responses Proper case function
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Chris Browne
Date:
Subject: Re: PSQL statement to delete 100 rows meeting certain criteria
Next
From: Rosser Schwarz
Date:
Subject: Re: Using || operator to fold multiple columns into one