Answers for "delete records postgresql"

delete all entries postgres

DELETE FROM tablename;

delete entries in postgresql

DELETE FROM table
USING another_table
WHERE table.id = another_table.id;

delete from select postgresql

DELETE FROM mytable 
WHERE ctid IN (
    SELECT ctid
    FROM mytable 
    GROUP BY s.serialId, s.valuetimestamp
    ORDER BY s.serialId
    LIMIT 10
)