Re: [GENERAL] Large XML file

2008-12-15 Thread Peter Eisentraut
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.

[GENERAL] Large XML file

2008-12-15 Thread Letinarh
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`?) 2. How can I parse it without uploading it. assuming that xml file and postgresql are located on the same server.