I have 2 db sequences and 2 tables: CREATE SEQUENCE products_seq MINVALUE 1 MAXVALUE 9999999999999999 START WITH 1 INCREMENT BY 1; CREATE SEQUENCE reviews_seq MINVALUE 1 MAXVALUE 9999999999999999 START WITH 1 INCREMENT BY 1 CACHE 10; CREATE TABLE IF NOT…
Suppose the following: create schema bv; create table bv.user(id bigint primary key); create table bv.user_photo ( id bigint primary key, url varchar(255) not null, user_id bigint references bv.user(id) ); insert into bv.user values (100), (101); insert into bv.user_photo values (1,…
I have a SQL query like this: select age_group, sum(member_count), sum(discharge_count) from newtable group by age_group order by age_group; It is returns these results: age_group member_count discharge_count 18-64 Years 150 245 6-17 Years 185 325 65 and Above Years 125…
I have this SQL query: select date_trunc('month',created_at-'6d 18:06:56'::interval) +'6d 18:06:56'::interval as created_at, count(*)filter(where status='ACTIVE') as active, count(*)filter(where status='BLOCKED') as blocked from companies where now()-'12 months'::interval < created_at group by 1 order by 1; I tried to use it into Spring…
I have database in PostgreSQL and I currently have a query that I found from Stackoverflow to get the list of tables with it's current row count. WITH tbl AS (SELECT table_schema, TABLE_NAME FROM information_schema.tables WHERE TABLE_NAME not like 'pg_%'…
I have the following PostgreSQL table: create table companies ( id bigserial primary key, created_at timestamp(6), name varchar(200), status varchar(200) ); I would like to split the result by month and to pass the months by param. How I can…
I want to improve performance of my queries using GIN index on jsonb column for pattern matching For example, I have a table defined as: CREATE TABLE my_table ( uuid text, doc jsonb ); In every row of table doc…
I am hitting a SQL query below and resulting as show below. SELECT column from Table LIMIT =1 GLOBE-WORLD-AIRPORT-Azerbaijan-country-SECRET-ABORT Here I want to get the data Azerbaijan-country as my result. My logic should fetch the content after the third -…
I am looking to number the rows of my output with four 1’s, then four 2’s etc etc regardless of the value in the rows. My data is sorted by week so I am basically trying to group the weeks…
I have tables of assets(say 3 assets) which has following columns assetID status updated_date Now every week there will be a change in status of the few assets. So only changed ones will be populated into this table. So if…