i am new and trying my hand on n8n,
i have issue trying to get data out from the postgres database
i have connected my n8n postgres node to my postgres (in docker) with the credentails.
my table name in postgres is “student_object” and its fields are student_id, name, hobby, age
where student_id is string, name is string, hobby is string, age is integer. They are just created in the table based on standard postgres sql statement.
my query is : select * from student_object;
i also tried : select student_id from student_object;
When i perform query by filling the “query” field in the parameter, the result return is “Entries exist but they do not contain any JSON data.”
Does the table in postgres need to be saved in json to work with n8n? What if my data is a flat one in postgres saved using standard postgres method ?
Please advise. thank you