I am having N number of tables(around 100) as shown below. These are base tables CREATE TABLE table1 ( SignalID NCHAR(36) NOT NULL, Timestamp VARCHAR(24) NOT NULL, Value DOUBLE NOT NULL ) CREATE TABLE table2 ( SignalID NCHAR(36) NOT NULL,…
I have a table where I record events. These events will come into the system once a minute, per user - on the order of 10's of thousands a minute. But I don't need to save all of them. If…
I have an "issue" (probably coming from my understanding of the json, jsonb and jsonb[] types) which is the following: My team and I insert 3D coordinates records into a table whose column type is jsonb[]. The table contains an…
I have three tables 1. Account 2. dept and 3. managers In the managers table I need to add both account key and dept key as foreign key but one will null and other will have value, means if inserted…
friends. I'm creating a mini bank application that user makes input with his name and id and then have several options. My problem is that i want to check if the user exists inside the insert() method to avoid duplicate…
plz help me i develop one app with Django and my database in the PostgreSQL my database name is company and have many data one month ago i can backup but now! PostgreSQL not allow to backup i decided to…
Example 1: FROM table1 LEFT JOIN table2 ON table1.id = table2.id AND table2.flag = TRUE Example 2: FROM table1 LEFT JOIN table2 ON table1.id = table2.id WHERE table2.flag = TRUE Q1: Will both of these return the same number of…
I ran a simple delete query on a telemetries table to clear up some data but cancelled as it was taking really long. I noticed that after I cancelled the query some of the tables (all partitions of the telemetries…
I have a set of code that is importing a JSON file provided into a temp table as follows: DROP TABLE IF EXISTS tmp; CREATE TEMP table tmp (c JSONB ); sqltxt:='COPY tmp from '''||filepath||''' with (FORMAT TEXT, DELIMITER ''~'')';…
How can you get a list of values in a loop so that you can use it in the IN operator? It turns out that I need to declare the desired type, assign a list of values to the variable…