I have a table that keeps track of runs. It has the following columns: ID distance run_time run_date 1 10 01:35:00 2023-12-10 2 10 01:48:00 2023-12-16 3 10 01:25:00 2023-12-17 4 10 01:41:00 2023-12-23 I want to calculate the average…
I am having problems when "migrating" my query in which I parse a column with XML stored in it, i "migrating" from T-SQL to Postgres, since my current development requires it. In T-SQL this is my current query: My query…
i am building CRUD application i am able to read and delete data but i am unable to update data in the database table for the specific route, also when i tried to update data in the table with id…
I will have to produce a result set which returns the month in each year that produced the highest sales? The tables of interest would be the products table, the order table and the date-time table. The current ERD for…
I have a postgres db that runs on an AWS RDS instance. It contains a somewhat complicated materialized view (created by four left joins). I would like to drop it but the query never completes (no error message, it seems…
I'm trying to connect to a cloud sql postgreSQL instance using Python code from my local machine (locally) and using the Private IP of my cloud sql instance. from google.cloud.sql.connector import Connector, IPTypes import pg8000 import sqlalchemy from sqlalchemy import…
I'm working on a Bash script to parse Postgres error logs and pull out log entries between certain dates/times. The complicating factor is that entries can be multiline, and only the first line includes the time stamp. Log entries look…
I have two tables - accounts, inf_accounts. There is a daily update on millions of rows from inf_accounts to accounts. I tried two updates: UPDATE accounts acc SET account_status=(SELECT account_status FROM inf_accounts inf WHERE acc.account_number = inf.account_number); This one performs…
Context I have the table (hs_buildings) in my Postgresql DB containing the Point location of my buildings (hs_buildings.coordinates). Then I have a raster containing the land use in stored in a Postgresql raster table (named hs_raster_values). The resolution of the…
when doing an UPSERT statement with postgres, such as INSERT INTO tab1.summary( table_name, target_field, check_n) VALUES ('tab1', 'col1', 10), ('tab2', 'col2', 10) ON CONFLICT(table_name, target_field, check_n) DO UPDATE SET check_n = 20; , returns nothing as data output, however, the…