I'm trying to deploy my postgresql v16 database to Azure via pgadmin v4.83. I start the Register -> Deploy Cloud Instance wizard and enter my tenantid and then press the "Click here to Authenticate yourself to Microsoft Azure" button. After…
I am not able to execute a query with the java Query Runner if the query contains a DO $$ - END $$ clause. The Prepared Statement Query in question: DO $$ declared_id integer := (select id from db.table where…
I have a couple of tables which have information about an activity(like an article), how do I get a column back that spits out a value based on some condition Learner Certificate view dt First 2023-10-09 Second 2024-01-03 Learner Certificate…
I have the following query to try and get a total of places within the range of a provided point, comparing against my table of places. All places have a geo column, defined as geo point default null. select count(*)…
I am trying to amend the value of a key in a table. I have a database (this is for Immich if relevant). See below details of the table. I am trying to amend "library.watch.usePolling" from "true" to "false". I…
I am learning docker and postgresql and I have problem with persisting data between the re-runs of the app. My docker-compose.yml: version: '3.7' services: web: build: . command: python3 /code/manage.py runserver 0.0.0.0:8000 volumes: - .:/code ports: - 8000:8000 depends_on: -…
Input: consecutive numbers from 1 to 100 - 1,2,3,...,100 Desired output: 1st group: 1, 2, 3, 4, 5 -> sum 15 (not bigger than 20) 2nd group: 6, 7 -> sum 13 (not bigger than 20) 3rd group: 8, 9…
This is my query to fetch the latest message from each room: SELECT MAX ( "Messages"."id" ) AS messageId, "Rooms"."id" FROM "RoomUsers" INNER JOIN "Rooms" ON "RoomUsers"."roomId" = "Rooms"."id" INNER JOIN "Conversations" ON "Conversations"."roomId" = "Rooms"."id" INNER JOIN "Messages" ON…
I have been asked to temporarily disable autovacuum in PostgreSQL 14.3. From 7 a.m. to 5 p.m., autovacuum is to be turned off, and at other times it is to be turned back on. I intend to achieve this by…
I can convert record to string by just doing myrecord::text. My problem is that my record has text fields which contain commas, and the resulting type cast text is comma separated. Thus, I cannot separate the resulting text in a…