I have the following table: product price date banana 90 2022-01-01 banana 90 2022-01-02 banana 90 2022-01-03 banana 95 2022-01-04 banana 90 2022-01-05 banana 90 2022-01-06 I need to add a non-unique ID column to the table. Every time the…
From the docs: "Indicates not to recurse creating indexes on partitions, if the table is partitioned. The default is to recurse.". Am I understand correctly that index will not be created on existing partitons? What kind of index will be…
I have a table "products" with a column called "store_id". This table has a lot af products from many stores. I need to select 4 random products from 4 specific stores (id: 1, 34, 45, 100). How can I do…
I use PostgreSQL I can run a single query per day, but it will take a long time to go through every day. The "zone" and "reader" also changes, so to run single queries every time will keep me up…
I would like to delete rows from my database that have the same name. I've checked Stackoverflow and found something like this: DELETE FROM my_table mt1 USING my_table mt2 WHERE mt1.my_name = mt2.my_name AND mt1.unique_id<mt2.unique_id; This of course works but…
I can get the rank alias with this query: SELECT *, RANK() OVER (PARTITION BY some_field ORDER BY value) AS rk FROM my_table Result: some_field value rk same 10 1 same 20 2 same 30 3 And I tried to…
I have installed Postgres cluster using zalando operator. Also enabled pgbouncer for replicas and master. But I would like to combine or load balance replicase and master connections, So that read requests can be routed to read replicas and write…
I have a question: we have a table that has (among other stuff) a couple of IP/port pairs that I would like to be globally unique to avoid crosstalk in streaming binaries that use this configuration. Assume a table as…
What I want is to send encypted data from my app to PostgreSQL database via formatted string (query) by using Npgsql. Problem is that after sha256.ComputeHash() I get byte array which I'm trying to send by inserting it into my…
When I fetch data from my PostgreSQL database, it comes in the following format: 2022-11-30T21:00:00.000Z and it's not a string; it's in the form of a date object. The library that I'm using to work with dates is dayjs. So…