Insert Record Into a Table Using a Stored Procedure

This example pipeline demonstrates how to create a stored procedure and call the stored procedure to insert a record in an existing table. This pipeline runs an SQL query containing a JOIN command to collate data between two PostgreSQL tables.


PostgreSQL Execute Example Pipeline

Download this pipeline
  1. Configure the PostgreSQL-Execute Snap with a call statement to trigger the stored procedure by passing values for GenreId and Name in the Genre table.

    Postgresql-execute-snap.png

  2. Configure the Table Name and GenreId in the PostgreSQL Select Snap as follows to fetch the inserted record to verify the record has been inserted.
    postgresql-select-configuration
  3. On validation, the PostgreSQL-Select Snap fetches the previously inserted record.

    postgresql-select-output