PostgreSQL Delete

Use this activity to execute an SQL Delete to delete the record and return the information based on the returning clause specified in the delete query.

Settings

The Settings tab has the following field.

Field Description
Connection Name of the PostgreSQL database connection from where information is retrieved. You can select the connection from the Connection dropdown list.
Select Schema

Select the appropriate schema from the PostgreSQL database.

Input Settings

The Input Settings tab has the following fields.

Field Description
Delete

An SQL statement used to delete the record from the table. You can construct prepared SQL queries by using substitution variables (or parameters) of the form ?<fieldname> in the query statement.

As you begin typing a query, the auto-suggest dropdown menu displays relevant keywords, table names, and column names that you can select from. To choose a column name from the dropdown menu, first type the table name followed by a period (.), which shows the list of available column names for that table.

If you are unfamiliar with the tables present in the database schema, press the ctrl+ space key in the query editor to obtain auto-suggestion of all the tables and keywords present in the database schema.

Each substitution variable identifies an input parameter whose mapped value is substituted into the substitution variable at run time. Input and Output tabs are populated based on the query.

End the query with a semicolon (;) to fetch the metadata in the table at the bottom of the query.

The following example represents a typical delete query: 

DELETE from public.student where name = ?name returning id;

For the above delete query, the output field is generated for id from the returning clause and the input field is generated for name (VARCHAR). In addition, the mapped value for the field name is substituted into the substitution variable ?name.

  • Call Procedure and Call Functions Syntax:
    • With no parameters
      Call  Procedure_Name( );

Select Function_Name( );
    • With prepared parameters
      Call  Procedure_Name(?Param1 , ?Param2);

Select Function_Name(?Param1, ?Param2);
Manually Configure Metadata Set the Manually Configure Metadata field to True to fetch table metadata manually. For more information, see Manually Configuring Metadata.
Fields The grid is provided for informational purposes only.

Input

This tab displays the input schema of the activity as a tree structure. The information in the schema varies based on the delete query provided. The fields that are selected on the Input Settings tab are available in the schema. You can either hard code the values or map them to a field from the output of a preceding activity in the flow using the Mapper.

Output

The Delete activity returns the number of rows affected by the query.

Loop

If you want this activity to iterate multiple times within the flow, enter an expression that evaluates the iteration details. Select a type of iteration from the Type menu. The default type is None, which means the activity does not iterate.

Refer to the "Using the Loop Feature in an Activity" topic in TIBCO Flogo® Enterprise User Guide.

Retry on Error

For more information about the Retry on Error tab, see the "Using the Retry on Error Feature in an Activity" section in the TIBCO Flogo® Extension for Visual Studio Code - Developer User Guide.