# Creating a PostgreSQL table

## Procedure

1. Double-click the tCreateTable component to open its Basic settings view.
2. In the Basic settings view, and from the Database Type list, select Postgresql for this scenario.

   ![](https://help.qlik.com/talend/en-US/components/8.0/Resources/images/tpostgresqlscdelt_scenario_create_table.png)
3. 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.
4. In the Table Name field, fill in a name for the table to be created, employee in this example.
5. From the Table Action list, select Create table if not exist.
6. 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. ![](https://help.qlik.com/talend/en-US/components/8.0/Resources/images/tpostgresqlscdelt_scenario_schema_tcreatetable.png)