I have a column with numbers - 1,2,3...100. 5 of them looks like 1_, 3_, 5_ So, actually I have 1, 1_, 2, 3, 3_, 4, 5, 5_, 6, 7, 8 ... I did the query: SELECT c
I have logged into my database as the database owner (a superuser as well) and have created a role_write role with nologin and noinherit flags. I've revoked the
Collecting psycopg2 Using cached psycopg2-2.9.3.tar.gz (380 kB) Preparing metadata (setup.py) ... error error: subprocess-exited-with-error × python setup
This script works fine when running on dbeaver, I can work with the new created temp table: SELECT someField INTO TEMP tmp_TableZZ FROM "_fdw
i'm trying to implement docker in my rails api but I keep getting this error PG::ConnectionBad: SCRAM authentication requires libpq version 10 or above. I've tr
I have a legacy Django project (django-1.1.29) and some tests in pytest (pytest-4.3.0), all running inside Docker. The database is PostgreSQL 10 and is a docker
.score.sh is given as #!/bin/bash pass=0; fail=0; if [ $? -eq 0 ];then worker=`ps -eaf|grep nginx|grep worker` master=`ps -eaf|grep nginx|grep master`
I have created Custom columns by SELECT 'CREATE VIEW myview AS SELECT ' || string_agg( format( '%I AS %I', column_name, co
PROBLEM: In an aggregate-state Axon SpringBoot application @AggregateIdentifier is of type UUID and PostgreSQL database column is of type UUID. When persisted o
I am new to web development in Python and would really appreciate some help. I am trying to set up psycopg2/peewee on WSL (Windows machine). In my Python code I
I have an issue with TransactionRollbackError: could not serialize access due to concurrent update while updating the table.I'm using postgres with odoo V13, th
I am writing a query to be used as databases view, it looks now like this: SELECT contact.*, contact_users.names AS user_names, contact_status.status_
I have a postgreSQL database set up in google cloud. To connect via SSL google cloud provides 3 .pem files, server-ca, client-cert and 'client-key'. I am using
Here is the specification of my PostgreSQL. PostgreSQL 12.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit server_encod
I don't understand why the code doesn't works on Android, it's the same code in Java and it's works on my laptop. I've already search on Google, Stackoverflow,
I am getting the below error on running this query CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; SQLSTATE[58P01]: Undefined file: 7 ERROR: could not open extensi
I've seen similar questions asked and the answer is typically to simply change "postgres" to "postgresql" in the database URL. However, I still see this error.
I have an Oracle database from which I am selecting a table from a remote postgres database, pg. The column mydate is of type date. select to_char(mydate,'mm-d
I'm populating a table like so: ... time_id = uuid.uuid4() location_id = uuid.uuid4() id = row['id'] sql = ''' INSERT INTO "my-schema"."example"(
I am just trying to write simple register/login system. I am trying to find if username exists. Here is the steps : Go localhost:3000/users/register page Fill i