This is my parent table acc_detial - ACC_DETIAL example - acc_id 1 2 3 Now i have 3 tables: ORDER EMAIL REPORT Each table contains 100 rows and acc_id are ForeignKey from ACC_DETIAL. In ORDER table I have a columns…
My task is to create a function that concatenates the first name and last name from two fields found on the same table. Table "cust": cus_id f_name l_name email 1 Jack Daniels [email protected] 2 Jose Quervo [email protected] 5 Jim Beam…
I am currently studying SQL and I am still a newbie. I have this task where I need to split some rows with various entries like dates and user IDs. I really need help +-------+------------------------------+---------------------------+ | TYPE | DATES |…
I have a table with b-tree index on column A (non-unique). Now I want to add a check for uniqueness of column A and column B combination when inserting, so I want to add a unique composite index (A, B).…
Let's say I have the following two postgres tables with the same field: CREATE TABLE table1 ( label VARCHAR(50) ); CREATE TABLE table2 ( label VARCHAR(50) ); I want label to be unique across both tables. That is, the following…
I'm trying to build a pandas df with an SQL postgres timescale db query and this works below but the problem is the query builds an enourmous file for the one point I am after /5231/REGCHG total_power. The data has…
I am trying the following Postgresql query with Prisma's $executeRaw function. But it is not returning the values inserted. Instead only returning the number of records inserted. await prismaClient.$executeRaw(` INSERT INTO table1 (name, place, animal, thing) SELECT * FROM table2…
First of all, sorry for bad title - I can't figure out how to write generalized formulation of my problem. I have a table in PostgreSQL with users and dates of their internships. It looks like this: user_id start end…
I need to monitor the ongoing flow of data using the latest created date for a set of tables. Basically, I need to batch run SELECT MAX(z_date_creation) FROM table_schema.table_name on a set of tables I retrieve with SELECT c.table_schema, c.table_name…
We have an application going on for more than four years and a lot of data was being accumulated during this period. With the push for new features all this time, implementing archiving and clean up procedures where pushed back…