PostgreSQL

Input (Required)

• DB Host                                                Host name or IP address
• DB Port                                 Port number
• DB Username
• DB Password
• Database Name
• SQL string or file

Advanced Input (Optional)

• CSV bulk data input
• Exclusion of # of headers
• Character set for output                                               default is utf-8
• Encoding option for bulk CSV file input                   default is utf-8
• Suppress Warning

Return Value

• Return value for SQL in String, CSV, or in File

Return Code

• 0 for Success
• 99 for everything else

Parameter Setting Examples

Example SQL file

--- insert static records

INSERT INTO foo (name, age)

values

('nobody me', 100),

(‘foobar', 200)

Return Code