PostgreSQL-3.1205.2220
 | PostgreSQL |
|---|---|
Author Jerry Chae
Primary Features The PostgreSQL plugin enables your bot to directly connect and manipulate the Postgres database.
|
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
Code | Meaning |
|---|---|
0 | Execution successful |
1 | SQL errors |
9 | Other failures |