I've been trying to make a query more efficient by bringing together counts from multiple tables. I have a schema similar to this: create table "impressions" ( id serial primary key, ip inet, ad_id integer references ad(id), user uuid references…
Trying to do a shopping cart in telegram bot using psycopg2 and aiogram, but the data does not appear in the "korzina" column code: connection.cursor(f'INSERT INTO bot_users(korzina) VALUES({id_tovara}) FROM bot_user WHERE user_id= {us_id}') connection.commit() types of column's: user_id | bigint…
I have a problem to map PostgreSQL expression below, that extracts hours/minutes/dow, to a CriteriaBuilder expression: select extract(hour from start_time) from meetings where id = 5; meetings have start_time field in a database that maps into ZonedDateTime start Java entity…
I've spent the last day trying to figure this one out, with little progress made. I've successfully connected my app to a postgres database, setup the prisma schema and tested a migration with a seed.ts file. Now my route.js file…
I have a table A, where data is a json column, and timestamp is a timestamp with timezone column: timestamp data 2023-08-29 13:00:00-04 { "a_123":{ "temp":85, "uv":5, "rain":0 }, "b_123":{ "temp":85, "uv":5, "rain":0 } } 2023-08-29 14:00:00-04 { "a_123":{ "temp":70,…
We're doing a Postgres native logical replication between two databases. Now, we're getting an error trying to update from the publisher one of thousand tables that we have. When we try to update the table it returns this error: ERROR:…
I cannot create any table or column in PostgreSQL with springboot and there's no exception observed. It's driving me crazy. I really need your help. here is my code. This is the model class @Entity @Data @AllArgsConstructor @Table(name = "doctor_info")…
I am developing a PostgreSQL Procedure using the plpython3u extension which let you use python procedural language into PostgreSQL. With the following code using plpy, I am able to retrive data form table and put it into pandas dataframe. CREATE…
I have this for query for a table of a size of 2 700 000 rows in Heroku Postgres 12.16: SELECT 1 AS one FROM "users" WHERE ( external_id = 18 AND (email = '[email protected]' OR uuid = '779c7963-67b2-43ea-b19b-028759a146dc')) LIMIT…
I'm trying to extract only a certain portion of a string URL field in my query. I am doing this in Amazon Redshift. The query is very simple, essentially SELECT email_id, url FROM emailsends WHERE date > '01-01-2023' Pretty simple…