loading a file into a field

Поиск
Список
Период
Сортировка
От Brian Sherwood
Тема loading a file into a field
Дата
Msg-id df8d2df50912310823p1d2e3fdu6496571484360be1@mail.gmail.com
обсуждение исходный текст
Ответы Proper case function  (Michael Gould <mgould@intermodalsoftwaresolutions.net>)
Список 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 по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: PSQL statement to delete 100 rows meeting certain criteria
Следующее
От: Rosser Schwarz
Дата:
Сообщение: Re: Using || operator to fold multiple columns into one