PostgreSQL Database Forum

Q: How to update properties value in the array of jsonb field? Hi All, I run Postgres13 (PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit) I have a jsonb field type (fieldname is test), like below JSON array format, how to update is_read properties in extras node to true where the...

Im a newbie in PostgreSQL. I have a mysql insert query in c++. You can see it below. I want to convert mysql db to postgresql. Im using #include <postgresql/libpq-fe.h> for it. Here is my mysql code: pstmt = con->prepareStatement("INSERT INTO public.comp_inventory(epp_mac_address,epp_data) VALUES (?,?)"); pstmt->setString(1,...

Hi, I need to encrypt one of the existing column data and perform full db backup and share that to dev team. Please share any tools available to do that. Thanks.

Dear All, I have been facing below issue when trying to export table data in CSV format only when used where condition. I dont see any issue if I dont use where condition. Eg: Succesfully copied to CSV dnsdb=> \copy domains to '/root/pgdata/mycsv.csv' csv; COPY Failing with below error when added where condition

These are the steps of indexing in Lucene given in our syllabus-: <Broken Link> I understand the second step clearly. But I don't understand the first and third step. It's not mentioned clearly in this figure imo. Can you clear my confusion? Plus the sources that I refer don't even mention it like this, they explain it differently. I'm not...

Hello, I'm fairly new to PostgreSQL and have a situation where I need to flatten a text column to two separate columns. Below is the query I'm using: SELECT s.CoolerShelf, s.ShelfPosition, FROM planogram CROSS JOIN LATERAL UNNEST(string_to_array(shelves, ','))

Hi. In one recent research, i fails to understand of how PostgreSQL work with physical memory when executing a queries. Perhaps, someone had experience in the analysis of this issue. All tests was acted on PostgreSQL 12, Debian 10. In first, we have an execution plan of query. The execution plan contains HASH JOIN operations (search by query...

We have setup an environment of Postgres 15 cluster thru etcd and patroni with the help of HAProxy. Can we use any commercial load balancer in place of HAproxy ? Like F5 or Fortigate

Hello, I have one query, written MySQL language, and there qork perfectly. But I like to use the same query, in postgreSQL and there get 2 times syntax error, and I'm not fing the issue. Here is my code: UPDATE "T_Status_Furnace" SET "Status_CG" = true WHERE EXISTS ( SELECT MAX(m2.t1 - m1.t1) as delta FROM "Table_1_Furnace_1" AS m1 ...

I found unexpected command that took max CPU Usage on Postgres database server https://ibb.co/7NfSV5C

Dear Friends, I have 2 tables in Postgresql. Table1 and Table2 .... There is a common field Table1.ARN and Table2.RN . My need is get all the data of second table which is not in the common data get by Table1.ARN=Table2.RN. Waiting your fast reply Thanks Anes P A

Hi everyone! I have a problem that I should solve in postgres sql, but I'm stuck. The bare data is a table named activity_logs : activity_time (timestamp) | action (int4)|item 1 (varchar) | item 2 (varchar)| This is a log table simplified. activity_time: is a timestamp when a user login/logout is attempted. Action: can be 1 - Login or 2 -...

Hi, I have written a procedure with multiple input parameters but while calling the procedure, i am facing the error. Procedure: CREATE OR REPLACE PROCEDURE public.sp_create_svc_accounts( IN orgid integer, IN bggroupid integer, IN vclabel character varying, IN traffictype character varying, IN channelcode character varying, IN...