I have two string columns a and b in a table foo. select a, b from foo returns values a and b. However, concatenation of a and b does not work. I tried : sel
I have a working query that is grouping data by hardware model and a result, but the problem is there are many "results". I have tried to reduce that down to "
I have a table with 2 columns; ID (int) and EntityData (JSON). I have created a filter object in form of a Dictionary in C#. I want to fetch all rows which sati
I am new to PostgreSQL and I was wondering if there is a direct way to just convert the timestamp values in a table to a different timezone using a function. In
I am trying to write a function that when my script pulls information from AD that it inserts new entries that don't exist and then update the ones that do exis
After the new typeorm release a have some troubles to work with migrations. Some time ago i was using that code and it work entities: ['./src/modules/**/infra/t
How can I find all Views and Tables with rules which depend on a given Table? I need this in order to find which views and tables I have to check if I want to
When I create a kafka connect connector with the debezium connector, it results in four database connections. Three of them remain idle, while one works as the
i am trying create postgresql container with this command in windows with WSL 2 integration enabled docker run -d --name pg-docker --restart=always --publish 54
If mysqli error is thrown while connecting to database, it could be detected as below. if ($mysqli->connect_error) { $this->Session->setFlash(__('
I am tying to insert null value to a postgres timestamp datatype variable using python psycopg2. The problem is the other data types such as char or int takes
I finally (think) installed successfully PostgreSQL and also de psycopg2 (I use Windows). Btw, is some way to check it's working properly? Well, the thing now
I am having issues with a large query, that I expect to rely on wrong configs of my postgresql.config. My setup is PostgreSQL 9.6 on Ubuntu 17.10 with 32GB RAM
From example where-col-in example and this answer, WHERE IN clauses should have query with parameters with following syntax const response = await db.any('SELE
Context When a function returns a TABLE or a SETOF composite-type, like this one: CREATE FUNCTION func(n int) returns table(i int, j bigint) as $$ BEGIN RETUR
In a 2-player game using PostgreSQL 9.6.6 as backend I have defined the following custom stored function for retrieving chat messages for a user: CREATE OR REP
I'm trying to create a Postgres database for the first time. I assigned basic read-only permissions to the DB role that must access the database from my PHP scr
I am testing some code which processes registration to a website. The java code is as follows (excerpt): if (request.getParameter("method").equals("checkEmail"
I see that log_connections enabled by default on Heroku PostgreSQL instance, but how I can get this log?
I created the django app, I have it connected to my local server with pgAdmin3. I want to have the django app push to bitbucket. But the problem is: How do I s