Given a table that looks like the following: +---------------+----------+ |title |enabled | +---------------+----------+ |Four |N | |Two |N | |Three |N | |One |Y | |Five |Y | |Six |Y | +---------------+----------+ Using keyset pagination and sorting by enabled, how…
# Example of PostgreSQL cluster apiVersion: postgresql.cnpg.io/v1 kind: Cluster metadata: name: test-db-cluster spec: instances: 1 imageName: ghcr.io/cloudnative-pg/postgresql:16.1 backup: barmanObjectStore: wal: compression: gzip encryption: AES256 data: compression: gzip encryption: AES256 --- I have here as encryption AES256, but how does postgres…
I really dont know why but my Dockerfile image cannot access my postgres db running with docker compose. Im using Linux Ubuntu // prisma.schema generator client { provider = "prisma-client-js" } datasource db { provider = "postgresql" url = env("DATABASE_URL")…
Currently having a problem with my pgbouncer setup. I am using pgbouncer with Odoo and Odoo requires connecting to postgres database for framework purposes. Below is the log I received from pgbouncer. It said that there were no such database.…
SELECT BTRIM('"enterprise"', '"') > Output = enterprise I need to use BTRIM function to trim the double quotes like above, with jsonb_array_elements function. I have a query like below, SELECT jsonb_array_elements(json_column->'Fields')->'field_name' as "column" FROM table_a Which returns column "Value1" "Value2"…
I'm using Java, Spring Boot, Hibernate and Lombok as a Maven project with PostgreSQL database. It used to work, but after my next changes hibernate can not create tables automatically to database. What I tried is: Changing packages localization changing…
I have a table in SQL containing a column in JSON format. Here is a sample of the SQL query output: I need for each row in this table to expand the JSON objects and values into new columns with…
when adding a unique index and then a PK to a partitioned table that already has that PK on a table partition, the PK creation fails with multiple primary keys for table X are not allowed Why this limitation and…
Im trying to make the next query making use of Kotlin SQL Exposed framework. SELECT interation_id, group_id, max(version) FROM interaction GROUP BY group_id; I have a table of interactions, and each interaction group can have multiple interactions, each one marked…
I have a list containing terms that vary in length from 1 to 10 words, with approximately 500,000 entries. My goal is to search for these terms in a long text (converted from a PDF, typically 1.5 to 2 pages…