Hi, I am working on a workflow to display the tables and the data inside a table from postgres database. The objective is to receive the schema name and table name from postman (will pass these values as Params in the GET request) and to use these values in the query. eg: If I want to run the quer…

So an expression like this would be working in principle if temperature2 is a table in the current schema: [image] What I suspect is happening here is that your first PostgreSQL node returns more than one item, meaning your expression won’t work anymore beyond the first item (since your are refer…

Hey @Dhanya_V_Sagar , Hope you’re doing well :slight_smile: You can use the Expression Editor to use the values you pass with the query parameters. The expression for the query can be as follow: select * from {{$json.table}}.tables where table_schema='{{$json.schema}}' Hope this is what you’re l…

Hi, Thank you for the quick response. select * from {{$node[“Webhook”].json[“query”][“table”]}}.tables select * from {{$node[“Webhook”].json[“query”][“table”]}} I had tried these expressions before but it displays errors error: syntax error at or near "." and error: syntax error at or near ";…

This would be PostgreSQL complaining about some malformed query. Which values would {{$node["Webhook"].json["query"]["table"]}} have in your case?

The node contains the name of table. [2021-11-25 (3)]

Hi. Thank you for the detailed explanation. I have enabled the execute once option and it works fine. I have one more doubt. Say I want to choose a value from the input data of the node, like the image you have shared (you have selected migration). The input data is displaying only the first ro…

This is not currently possible through the expression editor as it just previews the first item. You could manually write an expression including $item to reference a specific item though.

Here is the solution . use only variable name and not the expression [image] Query parameters not working with Postgres Questions Hi @Edward , welcome to the community! n8n would populate the query parameters using incoming data. So the Query Parameters f…

How to use output parameter from webhook node in postgres query?

Questions

d4dilip June 25, 2025, 11:36am 9

Here is the solution . use only variable name and not the expression

Topic		Replies	Views
How can i use parameters in postgres node frome two node Questions expressions , postgres	1	240	August 8, 2023
Query parameters not working with Postgres Questions postgres	5	4312	August 31, 2022
How to insert variable in postgres query Questions postgres	6	2456	August 24, 2022
Query Parameters not working with Postgres Connection Questions	2	141	June 12, 2025
Running sql query by AI into postgres Questions	3	429	May 20, 2024

How to use output parameter from webhook node in postgres query?

Related topics