How to filter the row which contains all vowels in the column value. for example, the table letters contains list of column value. str ---- apple orange education I tried the sql with like command. select str from letters where…
I'm working in a Django project and it has a postgreSQL db. I'm calling multiple times the model to filter the results: latest = Product.objects.all().order_by('-update_date')[:4] best_rate = Product.objects.all().order_by('rating')[:2] expensive = Product.objects.all().order_by('-price')[:3] But I wonder if it's better for performance and…
I'm trying to query a table using pandas.read_sql_query, where I want to match multiple columns to python lists passed in as param arguments. Running into various psycopg2 errors when trying to accomplish this. Ideally, I would provide a reproducible example,…
After various tests, I saw huge difference in execution time for those similar queries : select id from my_table where creation_date > (current_timestamp - interval '2 days'); -- 9s Plan: partition pruning parallel scan of 5 partitions select id from…
I want to get the list of last n number of table names present in a schema in a particular database. The problem is there are lots of tables and is not convenient to scroll through all of them to…
I am restoring a postgres database via .backup file from one postgres-14 instance to another: pg_restore -h localhost -p 5432 -U postgres -d mydatabase -v "mybackupfile.backup" The backup fails, complaining about pg_restore: error: could not execute query: ERROR: function public.uuid_generate_v1()…
I'm trying to join a new column to my current query that uses aggregate functions. I create this column with a new query that also uses an aggregate function from a different table but I'm not sure if a JOIN…
I have a table with a unique constraint CREATE temp TABLE tmp ( c1 int, c2 text, c3 int, UNIQUE (c2, c3) ); insert into tmp (c1, c2, c3) values (1, 'a', 2), (2, 'a', 1) Is it possible to…
In Postqresql, I have this query: select * from students where name like '%Huseyin%' When I run it, I want to get data that has name is "Huseyin", "Hüseyin", "Huseyın", "Hüseyin". How can I do this? I use Dapper. I…
If I run this query: select date, sum(orders) as "Total orders" from tbl where date >=1 and date <= 4 group by date How can I get the expected output as shown in the screenshot?