I dont know why, but since I was cloning my working repository I am using on AWS to a local machine and try to run it, I am getting the following error: "SCRAM-
I'm using sqlfluff to lint my postges code. I'm down to a single linting error, in my test code, that I dont know how to fix by adjusting my sql nor how to conf
I want a table like this which has scores column, and whenever basket1 or basket2 are added to table I want to update scores of the columns in basket.So say bas
I need to alter a table to modify the order of the indexes created from the composite key for the below mentioned changeset. <changeSet author="demo (generat
My date column "timestamp" is currently listed as: 2020-11-16 20:27:38.033 +0000 It's formatted as timestamptz and I've tried every search on here and google to
I want to add a field in my models that hold value like this field = [(1,2,3),(6,5,4),(5,6,7)] or field = [[1,2,3],[6,5,4],[5,6,7]] I am using po
select rooms from users where username='test_user'; **returns** {"roomID":[{"1":"test1"}]} I want to add to[{"1":"test1"}] this {"2": "test2"} --> [{"1":"t
If I have a Postgres database running on the host machine (os: Linux), and some service running in a container of docker-compose. How would I access the databas
I am trying to add the group by clause on the impala/Hive table but its not working. I am having the jobs details table which having job name and status column.
I have an object of the basic structure: [ { "a": 1, "b": 1, "c": 1 }, { "a": 2, "b": 2, "c": 2 }, { "a": 3, "b": 3,
Postgres has a time data type. I am trying to insert rows into postgres from a glue job. Given the code: applymapping1 = ApplyMapping.apply(frame = SelectFromCo
I'm using npgsql on my ASP.NET application to connect to a postgres database. On trying to open a connection, I get the following error: 53300: remaining connec
I'm in the process of migrating our database from Oracle to Postgres. We have a number of hardcoded queries in our spring boot application that now break as res
I'm working with a table that has values like this ID Name Value 123 Size 1 123 Size 2 123 Size 3 123 Type Shoes 234 Size 6 234 Size 7 234 Ty
I've two columns in text format containing street names and civic numbers. I'd like to set a query to order rows by street name and then by digits and by charac
When one orders results by multiple columns the database has to do something to compare NULL values (e.g. order them first last). But how can I replicate that
Trying to update some dates programmatically on Citus I always get [0A000] ERROR: STABLE functions used in UPDATE queries cannot be called with column reference
I'm working from and example in the psycopg3 documentation to copy a table from one database to another: link dsn_src = 'postgresql:///dev_db' dsn_tgt = 'postgr
I have tried to install PostgreSQL 10.6 on Win 7 SP1 32 bit and I got following error after trying to run pgadmin4: "postgresql application server could not be
After deploying django app on heroku the url after every form submission or link in site been press resulting with "?next=" inserts into the URL address, I don'