9951 explained code solutions for 126 technologies

postgresqlHow do I export data from PostgreSQL to an XML file?

Exporting data from PostgreSQL to an XML file can be done using the pg_dump utility. The following example code will export the table 'customers' from the database 'mydb' to an XML file named 'customers.xml':

pg_dump -U username -a -t customers -f customers.xml mydb

Code explanation

  • pg_dump: The utility used to export data from PostgreSQL
  • -U username: The username to use when connecting to the database
  • -a: Flag to include all table data
  • -t customers: The name of the table to export
  • -f customers.xml: The file name to export the data to
  • mydb: The name of the database to export from

For more information, see the PostgreSQL documentation.

Edit this code on GitHub