About Export Differences in Hyperstage


There are several important differences between exporting data from Hyperstage and exporting data from other DBMS engines.

Escape Characters

The Hyperstage and PostgreSQL Loaders support escape character definition and usage.

Exporting NULL Values

Hyperstage recognizes the following representations of NULL values when loading data from a text file:

NULL, \N, <field delimiter><field delimiter>

However, by default, Hyperstage only exports NULL values in the following representation:


This can be modified using the null modifier in the COPY TO command.