How to import XML large file in Postgresql

From: Gennaro Sivero <gensiv08(at)gmail(dot)com>
To: pgeu-general(at)postgresql(dot)org
Subject: How to import XML large file in Postgresql
Date: 2016-06-23 20:24:18
Message-ID: CACOSeqDWp_SveQkLoViTnLFX4HOdD8dxpGP6JF-EaF1jDVR=XA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgeu-general

Hello

I need to import an XML large file into a database table .

I've created a table with the following command:

CREATE TABLE mytable(xmldata xml)

A file containing data is on my desktop. How would I import this file into
my table?
Is there an existing utility, like SQLLoader in Oracle that does this?

Responses

Browse pgeu-general by date

  From Date Subject
Next Message Gunnar "Nick" Bluth 2016-06-23 23:37:09 Re: How to import XML large file in Postgresql
Previous Message Guillaume Lelarge 2016-05-18 13:22:27 Call for Papers - PostgreSQL Conference Europe 2016