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

Quote

Specify the quotation character used in the CSV file. By default, the double-quote is used.

Escape

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).

Delimiters

Specify the single character that separates columns within each row (line) of the file. By default, a comma is used.

NULL value

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

Delimiters

Specify the single character that separates columns within each row (line) of the file. By default, a tab character is used.

NULL value

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.