I have a column which type is JSON but it contains JSON strings like this: "{"a":1,"b":2,"c":3}" I want to update the values in the column with proper JSON objects without the quotes and escapes like this: {"a":1,"b":2,"c":3} I've tried the…
I am pretty new to Go and I am trying to find the best way to set up my db communication. Essentially I remember from my previous workplaces that in PHP you can create a class that represents a SQL…
I have been trying to accomplish an automatic update of a table based on a column value. Here is the example. The idea is that the user will enter their phone, but not their country like this: mobile_phone country '51682815'…
I got this SCD table: start_date end_date partition 2022-03-08 15:35:09.856 2022-03-09 14:57:36.610 1 2022-03-09 14:57:36.610 2022-05-18 13:26:31.195 2 2022-05-18 13:26:31.195 2022-08-02 10:12:02.441 2 2022-08-02 10:12:02.441 2022-09-01 11:10:01.019 2 2022-09-01 11:10:01.019 2022-09-01 11:10:20.777 1 2022-09-01 11:10:20.777 2022-09-01 11:21:26.526 1 I would…
how to get records from two tables where all for example statuses are true in the second table. Table A Table B id name id idA status 9 'name1' 20 9 true 21 9 false 7 'name2' 22 7 true…
In Postgres, I set out to write a SQL statement that would return various fields from one table, along with a column containing an array of tag strings that come from another table. I've made quite good progress with this…
Is there any way that I can see what is stored in those indexes? I understand the query mentioned below lists down all the schema indexes and their details: SELECT DISTINCT TABLE_NAME, INDEX_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 'your_schema'; (taken…
I am trying to design a database of customer details. Where customers can have up to two different phone numbers. When I run the Select * command to bring out the customers that match criteria, I get this: Name |…
I have a web application built on Node.js and I use Knex as my db tool. It has all worked perfectly for months, but now, one of the columns in my db is not updating correctly. I have the columns…
The following procedure is run on a table with 20M records. It stopped at ~560000 and I don't know why. I'm still learning DB monitoring/troubleshooting. This is on Aurora Postgres Serverless v2 with 6 ACUs (12 GB mem). The content…