I'm trying to return the "value": "Brunswick" WHERE "language": "en" from the JSON string bellow This returns the first in the list I don't know the i...

I have table with data: create table measure_app_scalemeasurement ( store_code text, certificate_id text, audit_ending date); insert into measur...

I need a way to create table and nextval sequence name dynamically in PostgreSQL, can this be done without brain meltdown? My thinking goes along the ...

I'm prepping a legacy PostgreSQL 9.5 database for upgrade. I need to remove OIDs from tables without locking the tables for long periods of time. I ha...

I was following the next video to add support for EF with PostgreSQL: https://www.youtube.com/watch?v=pRxG9ORD7Hk Yet, I got the next results while tr...

Testing out a LAMP like application, fails with: SQLSTATE[08006] [7] connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or dire...

I'm trying to read sheets and insert them into postgresql to make the staging tables in my etl_table. The function was working, but now I'm getting a ...

I have three tables Owner ----------------------- id | long name | string Animal ----------------------- id | long status | ...

based on the following data in the database: i would like to query for all the records where status = null, but the status of the previous step_no is...

We have a PostgreSql 15 server serving around 30 databases, one schema each, with the same layout. Each database is used by one application instance. ...

I'm creating a hotel booking tool for our desk/reception. My current SELECT doesn't compute the "final" sum()/CASE, meaning that as long as there are ...

I have a view that contains columns from multiple tables, one of these columns is created from a value in a jsonb in another table : CREATE VIEW my_vi...

I change parameter timezone and log_timezone in postgresql.conf by this doc: https://www.postgresql.org/docs/current/datatype-datetime.html From docum...

In PostgreSQL I have a table named info that has columns like so: kod_id, region I need to get a JSON response like this: "List of regions": [ ...

We have seen some of the indexes are getting failing with below error. ERROR: index row size 2976 exceeds byte version 4 maximum 2704 for index "idx1"...

I have a Scala project which fetches information to a postgress database. I set up the project with sbt, in Intellij. I used the sbt plugin sbt-assem...

I am preparing a CSV for loading onto a table using the SQL command: COPY table FROM filename WITH (FORMAT csv, HEADER) This particular table has a va...

I am using postgresql as my backend for Celery (v5.3.5). Celery is returning an SQL error when I call ready() on the task ASyncResult: sqlalchemy.exc....

I have two options: a) Adding three smallint[] (array) attributes to my (main) table, two of them will be empty/unused most of the time and the third,...

Is there a list of transactions that I can see that have not been committed yet? Example: Begin; delete from table where column IS NOT NULL; I have no...

Long-time lurker, first time poster. I am trying to put together a simple Shiny app that allows users to select a species (using a dropdown) and which...

Basically, on the ODBC Source, i can see the tables, i can preview the data, but i when i click on the columns menu nothing is returned and i cant sav...

I find my self sometimes needing to select many items of different tables based on a list of id's or other variables. Given that this list can contain...

I am trying to use postgis to find some stuff around a point with distance expressed in meters. I am on Symfony 6.3.7, doctrine bundle 2.10, postresql...

I have a table like this: CREATE TABLE shop_webhooks_logs ( id UUID NOT NULL PRIMARY KEY, shop_id UUID not null REFERENCES shop(id), topic VARCH...