Hi!
I’m having a little trouble…
Created a database:
CREATE DATABASE automatization;
CREATE USER automatization WITH PASSWORD ‘automatization’;
GRANT ALL PRIVILEGES ON DATABASE automatization TO automatization;
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
CREATE TABLE IF NOT EXISTS users
(
id UUID NOT NULL DEFAULT uuid_generate_v4(),
first_name VARCHAR NOT NULL,
last_name VARCHAR NOT NULL,
trello_user_name VARCHAR NOT NULL,
trello_user_id VARCHAR,
telegram_user_id VARCHAR,
active BOOLEAN DEFAULT TRUE,
created_at TIMESTAMP DEFAULT now(),
update_at TIMESTAMP DEFAULT now()
);
Add user:
INSERT INTO public.users (id, first_name, last_name, trello_user_name, trello_user_id, telegram_user_id, active, created_at, update_at) VALUES ('0ca0a17d-6c7a-41a7-a00b-1aad5f7f5f6b', 'first', 'next', 'trello_user', null, null, true, '2021-01-02 19:56:21.470209', '2021-01-02 19:56:21.470209');
When you call a query SELECT * FROM public.users or SELECT * FROM users, nothing is returned.
nodes
{
"nodes": [
{
"parameters": {},
"name": "Start",
"type": "n8n-nodes-base.start",
"typeVersion": 1,
"position": [
250,
300
]
},
{
"parameters": {
"operation": "executeQuery",
"query": "=select * from users"
},
"name": "Postgres",
"type": "n8n-nodes-base.postgres",
"typeVersion": 1,
"position": [
450,
300
],
"alwaysOutputData": true,
"credentials": {
"postgres": "Automatization_Postgres"
}
}
],
"connections": {
"Start": {
"main": [
[
{
"node": "Postgres",
"type": "main",
"index": 0
}
]
]
}
}
}