From: | "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | XML schema |
Date: | 2007-11-15 12:35:24 |
Message-ID: | 264855a00711150435r2f4446aek1d87bc0ddee859b0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
Sorry for the cross-post, but I wasn't sure where this should go. I
have a large XML file (about 7.5Gb) that is composed of about 17
million individual records. I have successfully loaded these records
as individual XML records into a table with 17M rows. However, I
looked around a bit and noticed that there are at least a couple of
XML schemas that have been available in the past (but don't look like
they are currently maintained) that enable XPATH queries directly on
the schema. Is the current XML datatype (in 8.3) the direction of the
future, or is something more akin to a dedicated XML schema (I think
this is the route that Oracle has gone) going to be important?
Thanks,
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Reg Me Please | 2007-11-15 12:50:34 | Re: Variable LIMIT and OFFSET in SELECTs |
Previous Message | Sam Mason | 2007-11-15 12:22:00 | Re: Enforcing Join condition |
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2007-11-15 12:41:52 | Building full-text index |
Previous Message | Kenneth Porter | 2007-11-15 08:23:13 | Re: Access rights for tablespaces, phpPgAdmin versus PgAdmin |