Transforming XML Data

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 5.x documentation.

Transforming XML Data

The Greenplum Database data loader gpfdist provides transformation features to load XML data into a table and to write data from the Greenplum Database to XML files. The following diagram shows gpfdist performing an XML transform.

Figure 1. External Tables using XML Transformations

Use these steps to load or extract XML data. Keep in mind that the first three steps comprise most of the development effort. The last two steps are straightforward and repeatable, suitable for production.