Exporting postgres database data to XML

Question

I'd like to export whole PostgreSQL database to, preferably but not necessarily, a single XML file. I've found a lot of guides and solutions that help achieve the SQL>XML export, but for a single table. Is it possible, and if yes then how, to export whole database using PgAdmin or console command to XML format?

Gholamali Irani · Accepted Answer · 2017-12-14 12:27:08Z

2

In PostgreSQL you can do it like this:

SELECT database_to_xml(true, true, 'n');

see: https://www.postgresql.org/docs/current/static/functions-xml.html

answered Dec 14, 2017 at 12:27

Gholamali Irani

4,3707 gold badges32 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jack_Russell · Accepted Answer · 2017-12-15 08:49:45Z

0

Thanks for help @Gholamali-Irani. It seems to do something for 2 minutes when I'm executing this query in PgAdmin, but where is the file stored? Can I specify the file name and path where it should be created? I've also found something about xPath function but I don't really understand the way it should be used or maybe I'm searching the solution in the wrong way?

edited Dec 15, 2017 at 8:49

answered Dec 15, 2017 at 7:42

Jack_Russell

3436 silver badges22 bronze badges

1 Comment

jumptiger13 Over a year ago

Have a look here: stackoverflow.com/questions/50276474/… looks like you need to add 'to' and the path location

Collectives™ on Stack Overflow

Exporting postgres database data to XML

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related