I have 20+ materialized views that I use as some sort of pre-calculated cache for a number of operations. Each night at 3 AM I do automated sync with an external source, followed by a series of materialized views refreshing.…
I'm working on a CTE (probably not relevant), and I have two possible inner joins, but the second one should only be used if the first one is empty (it could be used anyway, in fact, IT MUST be executed…
I am trying to run a script with ./insert_data.sh; and I get an error saying there is a syntax error at or near the "." Am working in PSQL, thanks Edit #1: My script: #!/bin/bash # Script to insert data…
I don't even know where to start with this one, or if it's even possible to do in PostgreSQL (or if I'll just need to handle it in my code) I have a table of Bills, which specify which day…
I have the following SQL query and the result of the query is shown below. How do i select multiple minimum values based on cnt column? SELECT a.id , COUNT(a.id) cnt from table1 a where a.id in (SELECT id from…
I've got a simple table, primary key and name. The string always starts with a capital letter but could have more capital letters than just the first character. I want to return all the uppercase characters in the name. select…
I have created a controller that in order to delete records of my Sequelize Model, but right now I am having a trouble that I do not know how to after you delete a record it must change the defaultValue.…
When I retrieve data using Select date,type,value from table1 It show the values like below. But I want to customize it like below Can anyone give me idea to do this?
I'm new to trigger functions and PostgreSQL, and I'm trying create a calculated field combining other fields (I know that this might violate the normal forms, but I'm working with a pre-existing naming convention). The goal is to have the…
I have the following table in postgres: Table "public.items" Column | Type | Collation | Nullable | Default -------------+--------------------------+-----------+----------+--------------------------------------- id | integer | | not null | nextval('items_id_seq'::regclass) wildcard | character varying(255) | | not null | The wildcard column…