I have a Postgres table with these columns: id int8 , user_id varchar , is_favorite boolean , join_time timestamptz I want to delete some rows in this table with some conditions: Keep a maximum of 10 rows for each user_id.…
I am trying to find a way to delete all rows with NULL values in a table. On this post, I saw that you can't specify a target table from updates in the FROM clause. Therefore, I tried building a…
I have the table contacts which contains duplicate records: id name is_contacted created_at I need to delete duplicates, but keep the first record(among the duplicates for each name) where is_contacted=1. If among the record duplicates there are no records where…
I want to delete 2 models from a postgreSQL production database that are no longer used but have data on them. I am a bit afraid of removing them from the schema and running prisma migrate dev and then having…
I have a table below with sample data. | id | type| cycle| datetimestamp | status1 | status2 | |:----:|:---:|:----:|:-------------------:|:---------:|:---------:| | 27 | AN | 123 | 2022-12-28 04:12:31 | Normal A | Normal A | | 27 | AR…
I am trying to embed a Delete operation in SELECT in postgres. Tried the following command but its not working.. :( select * from tasks where title ilike '% Delete from tasks where title ilike `%Re%` returning ( Select title…
I wanted to delete all records except the one with the highest value so I did CREATE TABLE code ( id SERIAL, name VARCHAR(255) NOT NULL , value int NOT NULL ); INSERT INTO code (name,value) VALUES ('name',1); INSERT INTO…
My table structure is roughly as described in this post: name processed processing updated ref_time abc t f 27794395 27794160 def t f 27794395 27793440 ghi t f 27794395 27793440 jkl f f 27794395 27794160 mno t f 27794395 27793440…
Tell me how to optimize the deletion of data from a Postgre table I have a table like this: CREATE TABLE IF NOT EXISTS test ( group varchar(255), id varchar(255), type varchar(255), ); INSERT INTO test (group, id, type) VALUES…
My problem is that when I try to delete records from a table in postgreSQL with python I can't do it, the method I created deletes 1 by 1, but when I want to delete 2 or more at once…