I have huge words table which I'm running LIKE query on: create table words ( id int, word varchar ) It works pretty long. Index doesn't help a lot, so I'm trying to partition it by word column: create table…
I have two tables: dates: date 2024-01-01 2024-01-02 2024-01-03 2024-01-04 2024-01-05 actual: business_date id 2024-01-01 1 2024-01-02 2 2024-01-04 4 2024-01-05 5 I want to join these tables on the condition date = business_date, but in the case where there's…
I have postgresql database locally. I want to create a postgresql user that does not have access to pg_catalog and information_schema. I want this user to only read data in the database and not fetch information related to database or…
I am performing an SQL query in bash like this: updated_records="select class, subject, teacher from main_a where date(updated_at) = '2024-03-07';" after running the query I am getting the results like this class | subject | teacher -----------+-----------+--------- A123 | maths…
Got this question for a while and wondering if there is any faster query. I have a table with multiple entries per ID, and would like to list all columns with different values for the same ID. ID Brand Type…
is there any way to write query without subquery?. i have with: with test as ( select 1 as user_id, 'sadasdasggg1' as order_id, sysdate - 1 as order_date from dual union select 1, 'sadasdasggg2', sysdate - 2 from dual union…
I have wasted a lot of time on this and I'm stumped. Anyone have some insight or work arounds? Thanks in advance for your attention... My PHP/PostgreSQL/NGINX app has been running on MacOS using PHP-FPM installed via Homebrew for years.…
ID Amount Brand 1 10 NULL 1 20 NULL 2 30 Mazada 2 NULL BMW 3 40 NULL 3 40 KIA 4 NULL Honda 4 NULL Honda Above is the original table, and my goal is to find out any…
Using PostgreSQL, how can I replace all forward slashes by a hyphen after 5 occurrences of a forward slash like so: https://this/is/a/very/long/url to this : https://this/is/a/very-long-url
I have a table that looks like the following descript timestamp START 1/1/2024 08:00:00 ACTIVITY1 1/1/2024 09:34:00 ACTIVITY2 1/1/2024 11:12:00 STOP 1/1/2024 13:00:00 I need a query that will return the description, timestamp, and the duration between the start and…