I have a simple Django project with a PostgreSQL backend and I can't seem to get rid of the Django security vulnerabilities warning signs on my terminal. Settin
There are 163 tables, and I want to add two columns in all. And columns should be added from the front. Please tell me how to do it on postgreSQL This is a tabl
I am running docker-compose in Github-Action. docker-compose.yml has following service definition for postgres postgres: container_name: postgres imag
I'm trying to deploy a simple Rails app in heroku but I'm getting this message in the heroku logs: PG::UndefinedTable: ERROR: relation "entries" does not exist
I have a (dynamically generated) file that includes a lot of SQL Statements that contain only data definition. Usually, I run the whole script as a single trans
I need to set the default DB schema for a Django project, so that all tables of all apps (including 3rd party apps) store their tables in the configured Postgre
I am trying to create a json object from my query using json_build_object as follows: Select json_agg(json_build_object('first_name',first_name,
I am creating a database & working on CRUD functions. I've run into a problem with the Delete functionality. I have two tables, connected in a many-to-many
The following code: SELECT ets.event_id, ets.event_date, dtn.don_date, dtn.don_date - ets.event_date AS date_diff FROM events ets, donation dtn GROUP BY ets.eve
I'm using DbUp to deploy to a PostgreSQL-14 database. When I try to create a function or procedure using SQL-language syntax, DbUp throws an Npgsql.PostgresExce
I'm using DbUp to deploy to a PostgreSQL-14 database. When I try to create a function or procedure using SQL-language syntax, DbUp throws an Npgsql.PostgresExce
We have a debezium source connectors working perfectly fine, and one of the properties set is, for example: "transforms.SetSchemaMetadata.schema.name": "myschem
I am struggling to create the correct prefetch behavior in Django. Here is the outline of the problem: Each Account has DailyQuotes, updated daily at different
Table def: CREATE SEQUENCE IF NOT EXISTS lazy_product_stock_id_seq; CREATE TABLE "public"."lazy_product_stock" ( "id" int4 NOT NULL DEFAULT nextval('lazy_pr
I have a set of data for some tickets, with datetime of when they were opened and closed (or NULL if they are still open). +------------------+-----------------
so i make this app in which you can make products. And those products have an image that was saved in a file while i was using this app localy. I deployed my ap
source code I want to use jsonb column type. When I used postgresql there is no problem. But when I use H2 I can not persist my entity. Native sql works but whe
I installed PostgreSQL 9 and the time it is showing is 1 hour behind the server time. Running Select NOW() shows: 2011-07-12 11:51:50.453842+00 The server dat
I am currently developing a flutter web app for tracking the information in students classes. The app is basically a task management app curated for students. I
I’ve been trying to deploy a django application with postgresql db on aws elastic beanstalk and i ran into many issues that i surfed and solved. Now the a