Procedure
- Double-click the tCreateTable component to open its Basic settings view.
-
In the Basic settings view, and from the
Database Type list, select Postgresql for this
scenario.
- Select the Use an existing connection check box and from the Component List drop-down list displayed, select the connection component to reuse the connection created by it, tPostgreSQLConnection_1 in this example.
- In the Table Name field, fill in a name for the table to be created, employee in this example.
- From the Table Action list, select Create table if not exist.
-
Click the [...] button next to Edit
schema and in the pop-up dialog box, define the schema by adding
four columns: id of Integer type as the primary key,
name and role of String type,
and salary of Double type.
In the end, a new table employee is created to store the employee data.