I have a docker compose file, which spins up postgres db. How can I run some psql commands after this container is started? This is what I'm trying to run: createuser postgres createdb DB createdb TEST_DB psql -d DB -c…
I am trying to set foreign key in the data models using gorm this is the code that I have written package main import ( "log" "database/sql/driver" "encoding/json" "errors" "time" "gorm.io/driver/postgres" "gorm.io/gorm" ) type JSONB map[string]interface{} func (j JSONB) Value()…
I've a Postgres table like this: datetime tenant_id orders_today 2023-06-25 10:00 tenant2 2 2023-06-25 10:00 tenant1 1 2023-06-25 11:00 tenant1 5 2023-06-25 11:00 tenant2 2 2023-06-25 12:00 tenant1 5 Note that a orders_today for tenant2 hasn't yet been generated for…
I'm trying to upsert a post: DROP FUNCTION IF EXISTS upsert_post; CREATE OR REPLACE FUNCTION upsert_post( title text, content text, short_id text DEFAULT NULL, image text DEFAULT NULL, status post_status DEFAULT 'draft', updated_at timestamptz DEFAULT NULL, published_at timestamptz DEFAULT NULL,…
I have a csv file that is not formatted in the correct way for AGE to load. I was on the task to transform it into a new one so that AGE could read it and create nodes, like it…
Facing issues while installing pl-debugger in Ubuntu 22.04 and following installation from this link I tried to install pl-debugger in Ubuntu 22.04 but facing an error shown below: Error If anyone had solved it previously, need help.
i have this model data structure: type Order struct { OrderEntry OrderEntry `db:"order"` } type OrderEntry struct { Order_uid string Track_number string Entry string Delivery Delivery Payment Payment Items []Item Locale string Internal_signature string Customer_id string Delivery_service string Shardkey string…
I have two Aurora PG databases, one at version 12.8, the other at 13.4. I have a table that looks like this: CREATE TABLE IF NOT EXISTS table1 ( id character varying COLLATE pg_catalog."C" NOT NULL, col1 character varying COLLATE…
so I have two tables, A and B. first I do a lateral join of A with one column (items) select A.id, item->>'id' as item_id, b.id from a, jsonb_array_elements(items) rx(item) then I do a right join with table b (has…
I'm having problems with the case statement in PostgreSQL. Here I want to change the output of the month (number) to text, like January, February, etc. select date_part('month', tanggal) bulan, case when date_part('month', tanggal)= 1 then 'January' when date_part('month', tanggal)…