PostgreSQL Loader Details (ttmig6105m000)
Use this session to specify loading properties when loading to a PostgreSQL database.
Field Information
- General Details
-
- Loader Command
- For PostgreSQL, the loader command is psql.
- Command Line Options
-
- Character Set (ENCODING)
- Specify the character set of the data in the data file.
- Field Delimiter (DELIMITER)
- Specify the field delimiter that is used in the data files. You can specify the field delimiter as a keystroke or through the ASCII value.
- On Error (ON_ERROR)
-
Specify what the loader does after an error occurs.
- ignore
- The loader continues processing.
- stop
- The loader stops processing.
- Logging (LOG_VERBOSITY)
-
Specify how the loader reports processing results.
- default
- The loader reports only a summary message.
- verbose
- The loader reports a message for each rejected row.
- Additional Options
-
- Additional Options
- Specify additional command line arguments for psql, if required.
- Any Information
- Specify any additional information, if required.