I'm trying to learn about how to make a docker container with a simple golang API that relies on a postgres database. My problems are two-fold: Attempting to connect to the postgres DB would yield me a "password authentication failed…
I have the following table: CREATE TABLE IF NOT EXISTS import.dre ( idmov integer, companynumber integer, idproduct integer, dtdate date, nrtank integer, dailybalance numeric, startbalance numeric, endbalance numeric ) Populated with the following query (10 first lines only): INSERT INTO…
I have a multi column table that I have derived by joining other tables UserId. Attempts. quizno First 1 assd. First 2 ffjfjf. Second 1 cbcbc. Second 2 tititi. Second 3 cncncn. I want a table that returns the row…
I am running Postgres on a Docker container. I have been trying to following the example show to deploy scripts using Sqitch from the following page: https://metacpan.org/pod/sqitchtutorial Now I have got as far as creating my folders for Deploy, Revert…
I would like to calculate the fraction of rows fulfilling some criteria. So something like this: (SELECT COUNT(*) FROM table WHERE col_name > crit) / (SELECT COUNT(*) FROM table) However, this creates a syntax error when I tried it. How…
Say I have two tables, 'users' and 'restaurants'. Users Table: user_id email u_name 1 [email protected] John 2 [email protected] Jane Restaurants table – here owner is the foreign key referencing user_id restaurant_id r_name address owner 1 KFC New York 1 2…
Remote server is running on Rocky Linux 8.9 (Green Obsidian). It had PostgreSQL 10 previously installed. This version lacks features essential to my application such as generated columns. I uninstalled v 10 using rpm, went to the official PostgreSQL repository,…
I have a database of songs, and I want to find duplicates: With the exact same title, e.g. "itsy bitsy" vs "itsy bitsy" OR with one title the substring of the other, e.g. "itsy bitsy" vs "itsy bitsy spider" I…
Used Homebrew to install Postgres@16 on Mac OS X Sonoma 14.3.1. brew install postgresql@16 When I come to connect: psql -U postgres -h localhost psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: auth_permission_dialog.dialog_executable_path is not a…
Node Js (express) server responds to requests via cUrl, but gives infinite load when requested via Postman or browser. There are no errors Found similar tracks, but none of them helped me. Can you tell me what this might be…