NodesDatabase Nodes
Edit Page on GitHubPostgreSQL - Create Table
Create a new table in PostgreSQL database
postgresdatabasecreatetableddlHard5
Description
PostgreSQL - Create Table node allows you to create a new table in your PostgreSQL database by specifying the table name and column definitions.
Common Use Cases
- Set up database schema for new applications
- Dynamically create tables based on user input or application needs
- Automate database management tasks
Inputs
The input connections this node accepts:
NameDescriptionTypeFlowThe flow of the workflowFlowTableName of the table to createTextSchemaSchema name (optional, defaults to 'public')TextColumnsArray of column definitions [{name, type, constraints}]JSONIfNotExistsAdd IF NOT EXISTS clause to prevent errors if table existsBooleanOutputs
The output connections this node provides:
NameDescriptionTypesuccessWhether the table was created successfullyBooleantableNameThe full name of the created table (schema.table)TextmessageSuccess or error messageTextToolThe tool version of this node, to be used by LLMsToolFields
The configurable fields this node provides:
NameDescriptionTypeTableName of the table to createValue:usersTextSchemaSchema name (optional, defaults to 'public')Value: publicTextColumnsArray of column definitions [{name, type, constraints}]MapIfNotExistsAdd IF NOT EXISTS clause to prevent errors if table existsValue: trueBooleanPG_CONNECTION_STRINGPostgres connection stringDefaultValue: postgres://user:password@localhost:5432/dbnameenvLast updated on