Database table creation and data insertion in Postgres

• Automate database table creation in Postgres for development environments
• Insert predefined data into a database to streamline testing processes
• Facilitate quick setup of database structures for applications

Manual trigger initiates the workflow Postgres node executes a query to create a new table Set node defines the data values for the new table Final Postgres node inserts the data into the created table

1. 1
   Import the workflow template into n8n
2. 2
   Click on the 'execute' button to run the workflow
3. 3
   Verify the creation of the 'test' table in your Postgres database
4. 4
   Check the inserted data in the 'test' table