Thread: XML to Postgres conversion
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. 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
Look at contrib/xml at http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml/. I never used this, but it might be useful. George Essig > 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. 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
Hi, Hey wow the contrib/xml looks most impresive. I'm so stoopid I've being looking around for xml solutions with even knowing about the contrib/xml in my beloved postgreSQL source. Thanks for the tip. Cheers Rudi. > Look at contrib/xml at > http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml/. I never > used this, but it might be useful. > > George Essig > > > 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. 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html
On Thu, Jul 11, 2002 at 09:23:39AM -0500, George.T.Essig@stls.frb.org wrote: > Look at contrib/xml at > http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml/. I never > used this, but it might be useful. > > George Essig > > > 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. 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 tDOM and nstcl might ne what you need, and a little coding. marc > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html