I have PostgreSQL SQL that should look for a backslash in a column called source_username and if it finds the backslash, it should replace the current value of the source_username column with the same value without the characters before the…
I have a Django application which I've decided to setup in container as follows: #docker-compose.yml version: "3.9" services: web: build: . command: python /code/manage.py runserver 0.0.0.0:8000 volumes: - .:/code ports: - 8000:8000 depends_on: - db db: image: postgres:13 volumes: -…
I've got a function which interacts with a postgres DB. The function takes a parameter called pagination_data_required (boolean). If pagination_required is set to true, the function executes a query as well as a query.count() which according to the documentation docs.peewee…
I have JSON data in PostgreSQL 13 table. I want to query this table in such a way that in the output it will print each element on the array in a separate column. I tried using the below query…
I have to tables that I want to join, order by two timestamps and get as result the distinct values (for several columns). But it doesn't work. See examples below: CREATE TABLE t1(myid int, myyear int, mycol int, mdate timestamp);…
My database is postgresql, which is placed on a Linux server. Now I want to communicate with it through the C# program that is on the Windows operating system. to connect to this database, there is a public encrypted file…
I'm running a dockerized Django application: only Django + Postgres on local. When I start the application and go to any localhost URL, it takes up to 3-4 minutes to respond. Then it works as expected, with 100-200 ms response…
I have a table representing a card deck with 4 cards that each have a unique ID. Now i want to look for a specific card id in the table and find out which card in the deck it is.…
In our organization, we are having common credentials to access the postgres databases, which every developers know, as it is hardcoded in application's connection string. Due to which, whenever a DML/DDL changes happens on databases, it is hard for us…
I have a postgresql table contains a list of email addresses. The table has three columns, Email, EmailServer (e.g., gmail.com, outlook.com, msn.com, and yahoo.com.ca etc.), and Valid (boolean). Now, I want to group those emails by EmailServer and then update…