PostgreSQL

Query, insert and update data from PostgreSQL.

Type: postgresql/v1

---

Connections

Version: 1

null

Properties

Name	Label	Type	Control Type	Description	Required
username	Username	STRING	TEXT		true
password	Password	STRING	PASSWORD		true

---

Actions

Query

Name: query

Execute an SQL query.

Properties

Name	Label	Type	Control Type	Description	Required
query	Query	STRING	TEXT	The raw SQL query to execute. You can use :property1 and :property2 in conjunction with parameters.	true
parameters	Parameters	OBJECT Properties {}	OBJECT_BUILDER	The list of properties which should be used as query parameters.	null

JSON Example

{
  "label" : "Query",
  "name" : "query",
  "parameters" : {
    "query" : "",
    "parameters" : { }
  },
  "type" : "postgresql/v1/query"
}

Insert

Name: insert

Insert rows in database.

Properties

Name	Label	Type	Control Type	Description	Required
schema	Schema	STRING	TEXT	Name of the schema the table belongs to.	true
table	Table	STRING	TEXT	Name of the table in which to insert data to.	true
columns	Fields	ARRAY Items [STRING]	ARRAY_BUILDER	The list of the table field names where corresponding values would be inserted.	null
rows	Values	ARRAY Items [{}]	ARRAY_BUILDER	List of field values for corresponding field names	null

JSON Example

{
  "label" : "Insert",
  "name" : "insert",
  "parameters" : {
    "schema" : "",
    "table" : "",
    "columns" : [ "" ],
    "rows" : [ { } ]
  },
  "type" : "postgresql/v1/insert"
}

Update

Name: update

Update rows in database.

Properties

Name	Label	Type	Control Type	Description	Required
schema	Schema	STRING	TEXT	Name of the schema the table belongs to.	true
table	Table	STRING	TEXT	Name of the table in which to update data in.	true
columns	Fields	ARRAY Items [STRING]	ARRAY_BUILDER	The list of the table field names whose values would be updated.	null
updateKey	Update Key	STRING	TEXT	The field name used as criteria to decide which rows in the database should be updated.	null
rows	Values	ARRAY Items [{}]	ARRAY_BUILDER	List of field values for corresponding field names.	null

JSON Example

{
  "label" : "Update",
  "name" : "update",
  "parameters" : {
    "schema" : "",
    "table" : "",
    "columns" : [ "" ],
    "updateKey" : "",
    "rows" : [ { } ]
  },
  "type" : "postgresql/v1/update"
}

Delete

Name: delete

Delete rows from database.

Properties

Name	Label	Type	Control Type	Description	Required
schema	Schema	STRING	TEXT	Name of the schema the table belongs to.	true
table	Table	STRING	TEXT	Name of the table in which to update data in.	true
deleteKey	Delete Key	STRING	TEXT	Name of the field which decides which rows in the database should be deleted.	null
rows	Criteria Values	ARRAY Items [{}]	ARRAY_BUILDER	List of values that are used to test delete key.	null

JSON Example

{
  "label" : "Delete",
  "name" : "delete",
  "parameters" : {
    "schema" : "",
    "table" : "",
    "deleteKey" : "",
    "rows" : [ { } ]
  },
  "type" : "postgresql/v1/delete"
}

Execute

Name: execute

Execute an SQL DML or DML statement.

Properties

Name	Label	Type	Control Type	Description	Required
execute	Execute	STRING	TEXT	The raw DML or DDL statement to execute. You can use :property1 and :property2 in conjunction with parameters.	true
columns	Fields to select	ARRAY Items [{}]	ARRAY_BUILDER	List of fields to select from.	null
parameters	Parameters	OBJECT Properties {}	OBJECT_BUILDER	The list of values which should be used to replace corresponding criteria parameters.	null

JSON Example

{
  "label" : "Execute",
  "name" : "execute",
  "parameters" : {
    "execute" : "",
    "columns" : [ { } ],
    "parameters" : { }
  },
  "type" : "postgresql/v1/execute"
}