About Export Differences in Hyperstage

In this section:

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


Top of page

x
Escape Characters

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


Top of page

x
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:

\N

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


WebFOCUS