Letinarh wrote:
> I have a large XML file (about 130 Mb) and I want to parse it using
> plpg/sql. here comes two questions:
> 1. How can I upload it? (only by means of `Large Object`?)
You can just insert it normally using INSERT or whatever other method
you use for getting data into the database.
> 2. How can I parse it without uploading it. assuming that xml file and
> postgresql are located on the same server.
PostgreSQL would have nothing to do with it. You can use som external
tool such as xmllint, depending on what you want to do. But the again,
130 megabytes (megabits?!?) are not really that large to devise special
workarounds.