Scenario : Input table 1 : need to compare the value of field2 of table1 with field 3 of table 2 example : select from svc_lz.fn_abc;svc_lz.fn_cde; so field 2 values of table 1 is present after 'select' i.e svc_lz.fn_abc and…
I have a table with two columns and the following data. I'm stuck with this table's structure and have no possibility of revamping it since the company has grown significantly and a lot of features depend on that particular format.…
Let's say I have the following table: WITH tbl AS ( SELECT 1 AS id, "Phone" AS product, 105 AS cost UNION ALL SELECT 2 AS id, "Camera" AS product, 82 AS cost UNION ALL SELECT 3 AS id, "Cup"…
I build an Excel document from a result set returned from PostgresQL database. I need to being able to distinguish between decimal (double) and non-decimal (integer) numbers returned by the result set. My SQL looks like followging: ... (select product,…
On every commit, postgres flushes WAL to disk through direct IO (configurable via wal_sync_method) to guarantee durability. Data files only need to be in shared buffers, can be flushed to disk later. My question is, on every commit, does postgres…
I am trying to fetch data and then pass the coaching data as props to another component so that i should render on FE i want to pass the props to the coachingCard Compoenet so that i can use the…
How to calculate median for selling_eur in this table? id listing_id category amount original_eur selling_eur user_id rounds_id 0 10088 m1-1579cd77-6863-469d-8798-9e1bef199d2f Category 2 2 nan 350.11 eu-central-1:6fcfad76-ef06-4ea6-9e14-9fa4a5d62b8f 31 1 10089 m1-2adfde90-de27-4048-aa3e-bc7e76c03b0c Prime Seats 4 nan 962.81 eu-central-1:6fcfad76-ef06-4ea6-9e14-9fa4a5d62b8f 28 2 10090 m3-024c20ad-e21d-4bb3-966e-44c69e760b15…
When I do docker-compose up, everything works fine and I got no problems, the backend connects to the database successfully, but when I do docker-compose stop and immediately after docker-compose start the backend can't connect to the database again ,…
I have two tables: Table Table I need to get info from table 1 and table 2 by id_banner (count of rows for equal id_banner is equal) For example, getting info for id_banner = 51 will post 3 different rows…
I'm trying to set up Change Data Capture (CDC) from a PostgreSQL database to Kafka using Debezium. I have successfully configured Debezium for CDC from a MySQL database, but I'm encountering issues when attempting to connect to a PostgreSQL database.…