Re: XML to Postgres conversion

Nathan Hill <cmsu_tech(at)yahoo(dot)com> writes:

> Hello:
>
> I am trying to figure out how to import xml documents
> into a postgres database. I am running PostgreSql
> 7.1.3 on Red Hat 7.2 at the moment. I have several
> dynamic xml documents that I want imported into the
> database on a regular basis(through cron entries).
> >From my research so far, I know that there is
> middleware available to perform this, but am having
> some difficulty in finding the actual applications. I
> am trying to stay with open source applications, if
> possible. Can anyone give me any suggestions or
> resources to pull from?
>
> Thanks,
>
> N. Hill

What is it precisely that you want to do? Do you just want save the
XML text to the database, or do you want to populate PostgreSQL tables
with information provided in the documents? A more thorough
explanation (including perhaps some sample XML and table schemas)
would be helpful.

Jason