Consider that I have a table t1 in my postgres database like so: CREATE TABLE t1 ( id SERIAL PRIMARY KEY, col_2 TEXT DEFAULT "foo", col_3 TEXT NOT NULL DEFAULT "bar", ... col_X INTEGER NOT NULL DEFAULT 42 ); And…
Imagine there are some data in Postgres table mytable: year (iso) week 2021 50 2021 51 2021 52 2022 1 2022 2 ... ... 2022 52 2023 1 2023 2 ... ... 2023 24 (current week) I need to delete…
I've setup a PostgreSQL database with Helm with this ConfigMap, that contains the initial script allows to create the databases and schemas I need: apiVersion: v1 kind: ConfigMap metadata: name: {{ .Values.postgres.configmap }} namespace: {{ .Release.Namespace }} data: init_script.sh: |+…
I migrated some data from my old db to new one with pk(id). What should I do in order to my new db continue from last id of migrated data. I encounter no problem while migrating but when project is…
I've a sample dataset order_num order_date email product_id 101 2023-06-01 [email protected] 1 101 2023-06-01 [email protected] 2 222 2023-06-02 [email protected] 1 333 2023-06-03 [email protected] 3 434 2023-06-05 [email protected] 3 444 2023-06-01 [email protected] 1 444 2023-06-01 [email protected] 2 677 2023-06-02 [email protected] 3…
We have about 200 GB files inside temp folder in PostgreSQL. And it's time to clear it but I'm not sure is it safe or not. Thats why I want to look at these files first. File names look like:…
I have created 2 databases called source_db and destination_db my source_db contains these things or i did these things while creating source_db -- Create the Customers table in the source database CREATE TABLE Customers ( customer_id SERIAL PRIMARY KEY, name…
I have installed Postgres v16beta1 and while installing that I got an issue that while configuring that using ./configure --prefix=$(pwd) -enable-debug it shows that: checking for icu-uc icu-i18n... no configure: error: ICU library not found If you have ICU already…
I need a sql regexp pattern that satisfied the following criteria. 1.Accepts chinese characters, 2.Accepts - a-z,A-Z,0-9,spaces 3.Rejects only special characters. I've tried the following. Select regexp_like((val)::TEXT , ('^[ !-’~¡-ÿ]*$')::TEXT) Or regexp_like((val)::TEXT ,('^[^[:ascii:]]+$')::text); The above query also accepts special characters…
I have a jsonb column in the following format: { "targets": { "01d7de90-57fd-4c4f-b7c9-3b956762fe25": { "id": "01d7de90-57fd-4c4f-b7c9-3b956762fe25", "name": "target1" }, "0f43e1fe-132e-464b-8284-4a9947a70c1c": { "id": "0f43e1fe-132e-464b-8284-4a9947a70c1c", "name": "target2" } }, "suggestions": [ { "items": [ { "id": "foo", "code": "item1" } ], "groupId":…