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…
I have a students_data table with a json column like this. CREATE TABLE students_data (doc_id INT, doc_data JSON); A row is inserted with doc_id = 101. The json content in the row is: { "document_type": "students_report", "document_name": "students_report_202406.pdf", "data": {…
I am using python to query an external api, transform the data and write it to a postgresql database internally. In that process, I am comparing the result from the api with existing data in the database using pandas and…
This Spring service, EmailsOutgoingService, is responsible for processing outgoing emails and it is scheduled to run every 60 seconds using the @Scheduled(fixedRate = 60000) annotation. Basically it checks the status of the email in the queue and performs operations on…
I am in the process of migrating from Oracle to Postgres with Ora2pg but I find this problem that the signatures on the Postgres side do not exist can you help me find the right solution ? What will be…
I'm connecting to Postgres 15.1 in R 4.3.0 using DBI 1.2.2 and dbplyr 2.3.2. Here is a statement that works: > my_table %>% mutate(date = as.Date(created_at)) %>% head %>% pull(date) [1] "2023-09-10" "2023-11-29" "2023-12-03" "2024-04-12" "2023-12-07" "2024-04-27" But this doesn't:…
I have the following code: query = "SELECT * FROM appointments WHERE service IN %s AND location LIKE '%London%'" values = (services,) # services is a tuple of strings. cur.execute(query, values) When I execute this code I get the following…
There is a database with online store customers, which has the following data: id buyer's; order number; date and time of the order; order amount. Data on customers and orders for 3 months. How to withdraw customers who made more…
This query: select id from user u where u.account_id = 600 returns: 61,71,68,69,70,118,116,117,248,381,384,325,265,393 and it works really fast. This query: select * from logs l where l.user_id in ( 61,71,68,69,70,118,116,117,248,381,384,325,265,393 ) works really fast too. But why is this query:…
Versions for My Environment: Ruby 3.2.2 Rails 7.1.2 PSQL 15 - (the gem is pg 1.1) Preface: I did not find a direct answer after some searching on the Internet, so I am posting this to show what I came…