6.1.9 Loading Empty Strings with EDB*Loader

Table of Contents Previous Next


6 Database Utilities : 6.1 EDB*Loader : 6.1.9 Loading Empty Strings with EDB*Loader

You can use the edbldr.empty_csv_field parameter to specify how EDB*Loader will treat an empty string. The valid values for the edbldr.empty_csv_field parameter are:
An empty field is treated as a NULL if it does not contain quotes and as an empty string if it contains quotes.
You can set the edbldr.empty_csv_field parameter in any context (i.e. with a SET statement, or in the postgresql.conf file). You can also use the PGOPTIONS environment variable to set the value of edbldr.empty_csv_field for an EDB*Loader session. For example, before invoking EDB*Loader, enter the command:

6 Database Utilities : 6.1 EDB*Loader : 6.1.9 Loading Empty Strings with EDB*Loader

Table of Contents Previous Next