Online Documentation for SQL Manager for PostgreSQL
Specifying input file parameters
Define the source (input) file parameters according to the instructions below.
CSV file parameters
Specify the quotation character used in the CSV file. By default, the double-quote is used.
Specify the character that appears before a QUOTE data character value in the CSV file. By default, the same character as for Quote is used (double-quote).
Specify the single character that separates columns within each row (line) of the file. By default, a comma is used.
Specify the string that represents a NULL value. Note that any data item that matches this string will be stored as a null value, so you should make sure that you use the same string as you used with Save Data Wizard.
Force not null
If this option is selected, each column selected below will be processed as though it were quoted and hence not a NULL value.
To select a column, you need to move it from the Available columns list to the Selected columns list. Use the buttons or drag-and-drop operations to move the columns from one list to another.
Text file parameters
Specify the single character that separates columns within each row (line) of the file. By default, a tab character is used.
Specify the string that represents a NULL value. The default is "\N" (backslash-N). You might prefer an empty string for cases where you do not want to distinguish nulls from empty strings.
When you are done, click the Next button to proceed to the last step of the wizard.