postgresql Questions

Javascript – unable to retrieve data using postgres and nodeJS

June 6, 2023
tanaya sharma
2 Answers

Here is how i've set the following files: index.js const express = require('express') const app = express() const port = 8000 const expense_model = require('./expense_model') app.use(express.json()); app.use(function (req, res, next) { res.setHeader('Access-Control-Allow-Origin', 'http://localhost:8000'); res.setHeader('Access-Control-Allow-Methods', 'GET,POST,PUT,DELETE,OPTIONS'); res.setHeader('Access-Control-Allow-Headers', 'Content-Type, Access-Control-Allow-Headers'); next(); });…

VIEW QUESTION

Postgresql – SQL query order by and limit taking a lot of time

June 5, 2023
Rishabh Sharma
2 Answers

I am querying a table with around 4M data with two types of skuID and using order by on version as there are around avg 5k versions of data for one skuID and fetching the top most versions using limit.…

VIEW QUESTION

Postgresql – Grouping row by previous row

June 5, 2023
Jon Wilson
2 Answers

I have Postgres data imported from a spreadsheet, where section headers have been imported along with the data. Is there a way to move the section headers to their own column? I have looked at window functions and I have…

VIEW QUESTION

How can I put an sql file into a postgresql database with a command line using URI?

June 5, 2023
PandaBaaka
2 Answers

I've wrote an sql file with some inserts I want to do in my database. Here's an example of what it's made of : -- User INSERT INTO users (user_id, credit, email, passwd, alias_login, user_id) VALUES (1, 250, '[email protected]', '123456',…

VIEW QUESTION

Postgresql – How can I define a variable in a SQL query saved in a jinja2 template and have it substituted with a value when the query is run by ansible?

June 5, 2023
Tms91
2 Answers

In my ansible palybook there is a task which runs a sql query saved in a jinja2 template on my database. - hosts: "{{ hosts_list }}" gather_facts: no vars_files: - vars/main.yml - vars/my_hosts.yml - vars/target_date.yml tasks: - name: generate report…

VIEW QUESTION

Cannot drop "ag_catalog" schema or other tables from PostgreSQL (ERROR: table "ag_label" does not exist)

June 5, 2023
Matheus Farias
2 Answers

On my postgres database, I have some tables that were created on the wrong schema ("ag_catalog") and I decided to drop it anyway since it was just for testing. I had also installed the age extension, but then I dropped…

VIEW QUESTION

Postgresql – "status": 400, "error": "Bad Request", spring boot , Create request

this is my first time working with spring framwork , and here i was trying to create two table classes and student , with a Many to one relationship , i can't create new student , and i try to…

VIEW QUESTION

Postgresql – SQL: How to Retrieve the Most Recent Association in a One-To-Many Relationship

June 5, 2023
j3d
2 Answers

Here below is a table that stores a one-to-many relationship where one user might be associated with one or more profiles: +----+---------+------------+------------------------+ | ID | USER_ID | PROFILE_ID | LAST_PROFILE_DATE_TIME | +----+---------+------------+------------------------+ | 1 | 100 | 101 | 04.06.23…

VIEW QUESTION

Postgresql – Data succesfully inserted, but table remains empty

Im currently working with SQL, and im currently using postgreSQL, sepcifically pgAdmin4. i have this table i called 'acetami' created with the following query: CREATE TABLE ACETAMI ( PRIMARYID BIGINT, DRUG VARCHAR(3000), Gender VARCHAR(3), AGE FLOAT, Adverse_event VARCHAR(100), ROLE_COD VARCHAR(2)…

VIEW QUESTION

Postgresql – Left join execute like right join [how to find the cause?]

June 5, 2023
Piotr Kazuś
2 Answers

I have simple query explain SELECT * FROM markets LEFT JOIN outcomes ON markets.uuid = outcomes.market_uuid WHERE markets.event_uuid = 'f286f78b-9e9c-4052-9785-7c908a8ab2c0'; and explain show me Merge Right Join (cost=63274.17..905696.60 rows=78271 width=8201) Merge Cond: (outcomes.market_uuid = markets.uuid) -> Index Scan using outcomes_market_uuid_index…

VIEW QUESTION