/
PostgreSQL

PostgreSQL

Dec 01, 2023

     

     

    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)

     

     

     

     

     

    Return Code

    Code

    Meaning

    Code

    Meaning

    0

    Execution successful

    1

    SQL errors

    9

    Other failures

     

     

    All Plugins