I'm trying to make an sql request that turned out surprisingly difficult to me (or maybe this is just the end of the day, sigh). I have 3 tables: Team: id 1 2 3 Team member table: id team_id 1…
I'm trying to display a table listing the Country codes (iso3166) in a postgresql db onto an html page using Spring Boot and Angular, the parameter name in the http response lists "number" when instead I want it to list…
I have a database having columns id and profile fields where profile fields is of the type jsonb id profile_fields 101 {"1":"Chess" , "2":"08-02-2001"} 102 {"1":"Hockey" , "2":"1996-06-09"} In profile fields the key 2 stands for Date of Birth .…
We have a PostgreSQL table with jsonb column. Some of the nodes in the json can come in as array or object in the input. I am trying to write a query that will give me the array length, if…
I am trying to get up the keycloak instance via using keycloak, and the compose file I used is below which I get it from https://github.com/keycloak/keycloak-containers/blob/main/docker-compose-examples/keycloak-postgres.yml # keycloak dependencies postgres-keycloak: image: postgres volumes: - postgres_data:/var/lib/postgresql/data environment: POSTGRES_DB: keycloak POSTGRES_USER: keycloak…
I have I have a column address with the string like this: Tow 10 Floor 223, Ward AA BB, District CC DD, City E F and Tow 110 Floor 23, Ward BB AA, District DD CC, City F E ...…
I've scoured the web for this one. What I'm trying to do: I have a table that has a primary id. I need to add a column called ex. order_number that automatically increments starting at 1000 and up from there.…
I have 3 table with excatcly same columns names. For this example lets say id,name,category, price. when i extract data i got the desired data where each field renamed to source table. it is not so convinet and i want…
i have developed a pgplsql function to receive array of dates the return the maximum date, but its not able to call the function: select 1, arcfm.array_max_date('{2022-02-03, 2022-06-05}'::timestamp[]) as max_date_time; CREATE OR REPLACE FUNCTION arcfm.array_max_date(in dates_array timestamp[]) RETURNS timestamp LANGUAGE…
I need to transform json objects with arbitrary keys, and integer values like so {"a":1, "sql":5} → {"a":{"f":1},"sql":{"f":5}}. I can't figure out the correct postgres jsonb methods. I've set up this db fiddle to make it easy to interact. Help…