We have this query that is running: SELECT concat_ws(' ', z.ticker, CASE WHEN a.date_approved IS NOT NULL THEN TO_CHAR(a.date_approved,'YYMMDD') WHEN z.date_recommended IS NULL THEN '000000' ELSE TO_CHAR(z.date_recommended,'YYMMDD') END, CASE WHEN s.ticker IS NOT NULL THEN 6 WHEN a.approved_recommendation IS NOT…
Attempting to rescue a PG::UniqueViolation error from a block in a Sidekiq (7.2.1) job in Rails (7.0.8) dev env, running on Ruby 3.2.2 revision e51014f9c0 with a local PostgreSQL 14.10 db on Ubuntu 20.04 fails. I'm launching the job from…
I have PostgreSql 15.3 running as a docker container. My docker run configuration is -m 512g --memory-swap 512g --shm-size=16g Using this configuration, I loaded 36B rows, taking up about 30T between tables and indexes. I loaded with about 24 parallel…
Noob question, but I cannot find answer anywhere. I want to pre-populate my database with some values, which refer to each other via foreign keys. But I see no way to do that without explicitly using IDs, which are supposed…
I am tasked with storing my company's data in a database and I am using PostgreSQL. I am using python to access and interact with PostgreSQL. My issues so far is that I have multiple excel datasets that are quite…
I am working on lanchain and had to store data in vector DB. I was following this document to install pgvector on windows and i was setting the PGROOT env variable, but even after setting the env variable by multiple…
i had 2 postgresql server with different version (9.6 and 13.9). I'm trying alter some varchar column from 20 to 50. As many views depend on it, I'm trying to avoid using UPDATE syntax in actual table by 'hacking' pg_atribute…
I have a requirement of order no which need to start with country code + some running number which is incermenting I did a trigger in following way. The order_no has a unique key constraint. Now the issue I am…
I need help splitting the string below using REGEXP_SPLIT_TO_ARRAY in a Postgres function: keyone="valone" key_two="val two" KEY_THREE=val three keyfour="http://sample.domain?par1=val1&par2=val2" keyFIVE=valfive and the resultant array should look like this: (keyone="valone",key_two="val two",KEY_THREE=val three,keyfour="http://sample.domain?par1=val1&par2=val2",keyFIVE=valfive) I ended up with this myarray := REGEXP_SPLIT_TO_ARRAY(mystring, E'\s(?=([^"]*"[^"]*")*[^"]*$)');…
I'm learning SQL from a website and they have this question for which my attempt below isn't sufficient and needs input. Summary of question: "Find the difference in days between the last post and the first post of the year…