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.
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.