Skip to end of metadata
Go to start of metadata



PostgreSQL


Author  Jerry Chae


Primary Features

The PostgreSQL plugin enables your bot to directly connect and manipulate the Postgres database.




Need help?

Technical contact to tech@argos-labs.com


May you search all operations,





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)



Text from Image



Text from Image

Return Code

Code
Meaning
0Execution successful
1SQL errors
9Other failures



All Plugins