I have a docker container that contains 2 images. My app and my database (postgres) They are both running, the app on :3000 and postgres on :5432 . When i run npx prisma migrate dev --name init I get the…
I have a query where in I divide 2 columns and multiply it by 100 in a new column(DeathPercentage). But this new column data type is automatically set into bigint, is there a way that i could change it to…
I am trying to create a table in a PSQL database with VSCode, but I receive syntax error. INT is underlined by vscode, if I delete it then TEXT and so on... Could you please give me any idea what…
I have a Postgres Table that has a column of "date[]" representing various dates that a user has a specific behavior, meaning each cell can have multiple dates (for example {"2022-10-31", "2022-10-10"}). This is connected to an API built in…
Based on the descriptions it seems that for the Read Replicas for Postgresql, the Write-Ahead Log Shipping is used. Is it logical? I have tables without primary keys, however when I spin up a read replica I have no problems…
Not sure if I have got the wording correct here, but I have this table: | name | pets | |-------|---------------| | bob | cat, dog | | steve | cat, parrot | | dave | dog | and I…
I am using PostgreSQL 14.5 I can classify the year by quarter using the Postgres keyword QUARTER as illustrated in the documentation just like SELECT EXTRACT(QUARTER FROM TIMESTAMP '2001-02-16 20:38:40');. And it works. The default quarter starts with January. Which…
I have my Dockerfile and docker-compose.yml configured to start my two services - this is my postgres db and Spring Boot app. Dockerfile: FROM openjdk:8-jdk-alpine ENV JAVA_HOME /usr/lib/jvm/java-8-openjdk-amd64/ RUN export JAVA_HOME COPY ./init.dump /docker-entrypoint-initdb.d/ RUN chmod 0755 /docker-entrypoint-initdb.d/init.dump COPY target/endlessblow-server-1.0-SNAPSHOT.jar…
I want to duplicate a specific teacher so that they appear twice in the output of a SELECT statement. Teacher Grade District Mr. Smith 3rd West Mrs. John 4th South Mr. Cameron 2nd North Mr. Cameron 2nd North Kirk Horn…
In my database, I am searching for a specific value. If that value does not exist, it should simply be added, but if it exists, a counter should be added next to it. So for instance, if the value Hello…