Helpful components right under your fingers

Use huge amount of integrated technologies to create best integrations

PostgreSQL

PostgreSQL is a powerful database engine with a uniquely advanced query optimizer and dozens of built in tons, making it an obvious choice for production environments world wide. Now you can integrate it with any web service.

Categories: Data sources
Featured applications for  PostgreSQL  connector
No applications available
PostgreSQL   connector features
Actions
Custom query
  • Execute query with data set return

    Parameters:

      • Connection string, String
      • Custom query, String

    Returns:

    • result, Array [Object]
  • Execute query with scalar return

    Parameters:

      • Connection string, String
      • Custom query, String

    Returns:

    • result, Object
  • Data operations
  • Delete items from table

    Parameters:

    • Connection string, String
    • Table name, String
    • Filter, String

    Returns:

    • rowsAffected, Integer
  • Insert single row into table

    Parameters:

      • Connection string, String
      • Table name, String
      • Item to insert, Object
      • Enable identity insert, Boolean
      • Identity field name, String
      • Result format, Integer

    Returns:

    • updatedObject, Object
    • rowsAffected, Integer
  • Insert items into table

    Parameters:

      • Connection string, String
      • Table name, String
      • Items to insert, Array [Object]
      • Identity field name, String
      • Enable identity insert, Boolean

    Returns:

    • rowsAffected, Integer
  • Save items into table (using INSERT or UPDATE)

    Parameters:

      • Connection string, String
      • Table name, String
      • Items to insert, Array [Object]
      • Identity field name, String
      • Enable identity insert, Boolean
      • Compare by fields, Array [String]

    Returns:

    • rowsAffected, Integer
  • Select data from table

    Parameters:

      • Connection string, String
      • Table name, String
      • Fields, String
      • Filter, String
      • Sort by, String
      • Result format, Integer

    Returns:

    • data, Array [Object]
    • count, Integer
  • Update single row in table

    Parameters:

      • Connection string, String
      • Table name, String
      • Identity field name, String
      • Item to update, Object
      • Result format, Integer

    Returns:

    • updatedItem, Object
  • Update items in table

    Parameters:

      • Connection string, String
      • Table name, String
      • Update functions (e.g. Count=Count+2, Name='Test'), String
      • Filter, String

    Returns:

    • rowsAffected, Integer
  • Database management
  • Create new table

    Parameters:

      • Connection string, String
        • Table name, String
        • Fields description, Array [Object]

    Returns:

    • tableMetadata, Object
    • success, Boolean
    • reason, String
  • Delete table

    Parameters:

    • Connection string, String
    • Table name, String

    Returns:

    • success, Boolean
    • reason, String
  • Returns table metadata by name

    Parameters:

    • Connection string, String
    • Table name, String

    Returns:

    • tableName, String
    • fieldsMetadata, Array [Object]
  • Get tables list for database

    Parameters:

    • Connection string, String

    Returns:

    • tablesMetadata, Array [Object]
    • databaseName, String
    • success, Boolean
    • reason, String
  • Stored procedures
  • Execute procedure and returns array of results

    Parameters:

      • Connection string, String
      • Procedure name, String
      • Parameters, Array [Object]

    Returns:

    • isSuccess, Boolean
    • result, Object
  • Execute stored procedure with single return value

    Parameters:

      • Connection string, String
      • Procedure name, String
      • Parameters, Array [Object]

    Returns:

    • isSuccess, Boolean
    • result, Object
  • Execute stored procedure without return value

    Parameters:

      • Connection string, String
      • Procedure name, String
      • Parameters, Array [Object]

    Returns:

    • isSuccess, Boolean
    • result, Object
Triggers
  • No triggers available for this connector