NodesDatabase Nodes
Edit Page on GitHubPostgreSQL - Check Table
Check if a table exists and get its metadata
postgresdatabasecheckmetadatatableMedium3
Description
PostgreSQL - Check Table node allows you to verify the existence of a table in your PostgreSQL database and retrieve its metadata.
Common Use Cases
- Validate if a table exists before performing operations
- Retrieve table schema information for dynamic queries
- Monitor database structure changes
Inputs
The input connections this node accepts:
NameDescriptionTypeFlowThe flow of the workflowFlowTableName of the table to checkTextSchemaSchema name (optional, defaults to 'public')TextOutputs
The output connections this node provides:
NameDescriptionTypeexistsWhether the table existsBooleancolumnsArray of column metadata (name, type, nullable, default)JSONtableSizeHuman-readable size of the tableTextindexesArray of indexes on the tableJSONToolThe tool version of this node, to be used by LLMsToolFields
The configurable fields this node provides:
NameDescriptionTypeTableName of the table to checkValue:usersTextSchemaSchema name (optional, defaults to 'public')Value: publicTextPG_CONNECTION_STRINGPostgres connection stringDefaultValue: postgres://user:password@localhost:5432/dbnameenvLast updated on