I have a jsonb column that looks like this: { "customer_id": "1", "address": "123 Main St.", "orders": [{ "order_id": "1", "catogory": "tools", "item_num": "15", "tracking_num": "GDR9F654F" },{ "order_id": "2", "catogory": "accessories", "item_num": "28", "tracking_num": "PHW3X543T" }] } The "orders" key…
In my postgres database I have a table I'll call users with a timestamptz type column updated_time. When I execute a select statement on this field I will get something like this - '2024-07-01 12:30:30.821 -0500'. However, if I turn…
I have a table in postgres and basically i'm trying to duplicate rows based on the delimiter @ in the description column. Here is my table: txn_id description 3332654 [email protected]@0.9397@$10.64@[email protected]@23.8235@$6.30@KRW@36,[email protected]@$41.84@[email protected]@1.5711@$12.73@[email protected]@0.6013@$8.32@[email protected]@10.6013@$18.32 3332655 [email protected]@0.8197@$11.64@[email protected]@21.8135@$61.30@KRW@36,[email protected]@$411.84@[email protected]@11.5711@$11.73 Using the below postgresql code, the rows are…
I have some partially columnar data like this: "hello", "2024 JAN", "2024 FEB" "a", 0, 1 If it were purely columnar, it would look like: "hello", "year", "month", "value" "a", 2024, "JAN", 0 "a", 2024, "FEB", 1 Suppose the data…
(https://i.sstatic.net/EiBqboZP.png) In the browser, I'm trying to add a new book to my books table but I keep receiving a Value error from django where for example I can't assign "'Virginia Woolf'": "Book.author" must be a "Author" instance. After I…
I am developing an accounting app where users can have a product with currency A. The value of the product can be escrowed using a cheque payment with currency B and this cheque payment can be paid in cash with…
I'm having to import a very large postgres database that I only have a pg_dump file for. The dump is 5.5Tb in size. I've seen many mentions to disable indexes and then re-index after the import to help speed up…
i need to get rows counts for specific columns with null and insert the same rows count output into a table with result set of the query. For this requirement, i tried with below pl/sql code block in postgres but…
I am dealing with a PostgreSQL (v14) query of this kind SELECT ..., EXISTS ( SELECT 1 FROM table2 t2 WHERE t2.fk = t1.id AND LOWER(t2.table_name) = 't1' ) AS t2_record_exists FROM table1 t1; and was hoping to extract the…
When I run the below query it executes correctly. But when called as a procedure throws an error Exception assignment source returned 2 columns 42601 From the analysis I found it's coming from here. ( SELECT string_agg(BB.File_N, ',' ORDER BY…