I'm new into postgresSQL, in my course in "Advance database" we are given a problem to simulate a crash at given location in postgres, is anyone got an idea how
I'm working on a Mac and trying to connect to my remote Postgres database in R Studio. Error First, the error: Error: nanodbc/nanodbc.cpp:1021: 00000: FATAL: d
I have a task to get key information about users in database. There are many left joins and the query works quite slow. I'm trying to optimize it somehow and I
I often read this site, but this is the first time I write, hope I won't make mistakes and apologize for my bad english. I get to the point: I have to develop c
I use lookup tables commonly and sometimes I have some default record in the Lookup table and I think for this record I can use 0 as Primary Key a as shown belo
I have this stored procedure to save a purchase with a token relate. But I'm facing an error when I try to call it in Nestjs/typeorm. I checked and I'm passing
I need to sync some postgres tables with elasticsearch and come to conclusion that the best solution for my case is the one described here. Unfortunately I'm st
everybody! I've finished a laravel project backend with postgres and it has a phpunit tests, everything it works. So, I did upload to Github. When I did "git
I am trying on PostgreSQL with the extension Postgis to get the geometry of a gps_trace that intersects a box, then i want to get one linestring for each distin
I need to create tables with different number of fields for different users. I want to create a schema for each user, and in it a custom set of tables. I can do
I'm on an Ubuntu-derived system (specifically pop_os from System76). I am trying to get Bucardo installed, but it appears to be failing because plperlu is not f
I have a C++ program that does something like the following: PGresult* res = PQexec(conn, "SELECT id, foo FROM tbl WHERE some_condition"); for (int r = 0; r <
I'm working on requirement to create a new table which has a column of type hstore. This is a Spring Boot app. I have created the JPA entity and run some tests
I'm using DBeaver to connect the postgres db and want to access the logs via DBeaver. I run the command below to find log destination and got stderr as the loca
For example col1 col2 1 2,3,4 Referring to the table shown here, if I want to return a row if col1=1 and col2 has 2,3. How to write query for this scenario? B
I'm working with two models in rails class Student < ApplicationRecord belongs_to :school has_many :lessons end and class Lesson
I have a table that looks like this: name val 1 1 2 2 3 1 4 2 5 2 6 10 For each row,
On PostgreSQL 13, I have a table define as such : create table my_table ( id serial8 primary key, title varchar(50), description varchar(512), frenc
I have Django application with postgresql on docker. I tried to insert data like this: import psycopg2 try: connection = psycopg2.connect(user="postgres",
I'm trying to add tens of thousands of Twitter profiles to a PostgreSQL database using the function below. The Twitter part works great - I get batches of 5000