Archives for: "January 2020"

January 31, 2020

PostgreSQL XML dump

Posted by on 31 Jan 2020 in Announcements

PostgreSQL (psql) has several xml output methods. For example, to dump a table to an XML file: # /usr/pgsql-9.6/bin/psql -v ON_ERROR_STOP=1 -d name_of_db name_of_db=# COPY (SELECT table_to_xml('name_of_schema.name_of_table', true, false, '')) to… Read More