Designing storage architecture for Petabyte-scale geospatial data; starting from scratch. Creating a MinIo cluster to store the objects in S3 buckets. To store
I am new to PostgreSQL and am struggling with the creation of a procedure to save the data in a new table. This is how the empty table is created CREATE TABLE e
I moved some of my data from PostgreSQL to BigQuery. Before PostgreSQL database was using 130 GB of storage, now I only need 30GB. However, in the Google Cloud
I have a PostgreSQL table where there is column which has array of strings. The row have some unique array strings or some have duplicate strings also. I want t
I use Typeorm and nestjs in my project. I have Schema: export class GroupEntity implements IGroup { // Attributes @PrimaryGeneratedColumn({ type: 'string' }
I have table which has productId and productVariantId columns. |id |userId|productId|productVariantId| ---------------------------------------- |1 |1
So, I'm currently working on Odoo and Postgresql. For some reasons, the database I tried to delete keeps appearing on pgAdmin. I have tried solving the problem
Just so you have it here is my defined prisma schema. Now if I read correctly in the prisma docs it said, that every field in which I do not declare a ? after t
Question: Is there a postgres query to add a new column to an existing table and to automatically populate that column for all rows of the table with a certain
I'm building a simple todo app where a user can have multiple lists and share them. Here is my Prisma Schema: model users { id String @
In PostGIS, what is the result of the && operation between two geometries? In my mind, && returns a boolean, but does return geometry this time.
I have a database that will count daily total amount of customer that does or doesn't have a transactions. Customer Column is a varchar data type Here is how
I am trying to call a stored procedure saved in the public schema using: const schema = await knex.raw("call create_schema(?, 'col1', 'col2', 'col3', 'col4', 'c
I've never had an issue like this before - normally brew install postgres works and everything is fine. I've had instances with this machine where I see "Mac OS
I want to run chainlink node on my local ubuntu machine. I used the following commands to install postgresql: sudo apt install postgresql adjusting firewall se
I found below shell-script(entrypoint.sh) from some GitHub Phoenix repo and I saw the same code in multiple Phoenix projects #!/bin/bash # Wait until postgres
I have the following simplified query SELECT id to_char(execution_date, 'YYYY-MM-DD') as execution_date FROM schema.values ORDER BY execution_date DESC,
Currently I am trying to truncate tables which have foreign key constraint on Postgresql 11.3. I tried doing this BEGIN; SET CONSTRAINTS ALL DEFERRED; TRUNC
Our solution: We have a trigger based partitioned table. BUT the insert trigger return NEW because hibernate must have rowcount 1 so all insert is inserted pare
This is the query I have so far, which returns the customers of a user. But I need it to also return the children of these clients. SELECT c.id_client, c.uuid,