I have a table: create table accounts_service.operation_history ( history_id bigint generated always as identity primary key, operation_id varchar(36) not null unique, operation_type varchar(30) not null, operation_time timestamp with time zone default now() not null, from_phone varchar(20), user_id varchar(21), -- and…
I use PostgreSQL 13.15 version and i don't understand how to make column case insensitive. This is table languages and column code is primary key. I want to make it case insensitive. CREATE TABLE IF NOT EXISTS public.languages ( code…
Although the value of the "statement_timeout" parameter in the config file in one of my Postgresql databases is "0", there is a timeout period in my database. What is the reason for this? config file: enter image description here When…
I use the id directly in the query, it has a low cost: -- Query 1. -- Nested Loop Semi Join (cost=2.27..280.78 rows=1 width=129) EXPLAIN SELECT * FROM view_companies_extra WHERE company_id iN ( SELECT id FROM companies WHERE id =…
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'm getting E: The repository 'https://apt.postgresql.org/pub/repos/apt bionic-pgdg Release' no longer has a Release file. on sudo apt update. That means that repo for bionic is not accessible. In my case for this time I can't upgrade Ubuntu version to a…
My foos each have a bar. At least they're supposed to. I now want to create and assign bars to all foos that don't. bar is completely detached from foo, it only has an id serial that serves as its…
I have the following SQL statement: SELECT DISTINCT e.eventid, e.objectid, e.clock, e.ns, e.name, e.severity FROM events e, functions f, items i, hosts_groups hg WHERE e.source = '0' AND e.object = '0' AND NOT EXISTS (SELECT NULL FROM functions f, items…
Context: I have this table called product and I am writing a script to clean up some old products, but have to follow rules, which can be deleted. One of the rules, is to only delete it if its not…
I have JSON data in PostgreSQL 13 table. I want to query this table in such a way that in the output it will print each element on the array in a separate column. I tried using the below query…