Im having this error when trying to connect to the database: [auth][cause]: error: password authentication failed for user "user" But i can connect to pgadmin normaly with the same credentials so I dont undertand whats going on. docker-compose.yaml services: postgres:…
I have 2 queries which give count of cases based upon a condition Query 1: Select count(unique c.caseid) as New_cases from caseinfo c where (c.crtdate between TO_DATE('2024/07/08') AND TO_DATE('2024/07/11')) and c.channel is not null; Query 2: Select count(unique c.caseid) as…
I'm trying to use CYCLE detection in PostgreSQL to avoid circular nesting of groups but cannot figure it out. I have the following PostgreSQL 16 table: CREATE TABLE groups ( id serial PRIMARY KEY, name text NOT NULL ); INSERT…
I have a question. I have the following scheme CREATE TABLE 'redirect3' ( id INT, short_url_id INT, browser SYMBOL capacity 256 CACHE, platform SYMBOL capacity 256 CACHE, os SYMBOL capacity 256 CACHE, referrer_domain VARCHAR, country SYMBOL capacity 256 CACHE, language…
i have created groups , which has members , each member has a group array displaying which they are part of . if i delete a group i want that user's group array also updates. i am using express and…
I made a Javascript nodejs project that stores data in Excel. I can access all columns in the entire file without any problems, but the value of the cells containing time information(12:30) is given as numbers(0.6423611111111112). Is it possible to…
Currently I'm trying to develop a PostgreSQL database schema, it has only 2 tables, one of which contains usernames. The difficulty is that for certain reasons I cannot store the username directly, so I have to store the hash (SHA256).…
I am developing an accounting app where users can have a product with currency A. The value of the product can be escrowed using a cheque payment with currency B and this cheque payment can be paid in cash with…
Below is the postgres table table1: CREATE TABLE table1 ( id INT PRIMARY KEY, name TEXT, skills JSON ); with below rows inserted: INSERT INTO table1 (id, name, skills) VALUES (1, 'Alice', ‘[ {“sid" : 11, "description" : “Cardio"}, {"sid"…
Postgresql tries to connect to a Db with the same name as the user, even when I specify the DB name in the connection string. Cadena de conexión: host=localhost port=5432 user=carsUser password= dbname=the-new-cars sslmode=disable 2024/06/22 16:00 Error al hacer ping…