postgresql delete limit

Solutions on MaxInterview for postgresql delete limit by the best coders in the world

showing results for - "postgresql delete limit"

1DELETE FROM logtable
2WHERE ctid IN (
3    SELECT ctid
4    FROM logtable
5    ORDER BY timestamp
6    LIMIT 10
7)
8

similar questions

postgresql reset serial counter after deleting content postgresql delete type postgresql reset auto increment restart postgresql delete db postgres postgresql reset sequence delete entries in postgresql delete all entries postgres postgresql reset auto increment index how to drop a trigger in postgresql postgres sql alter table delete row postgres delete last row postgresql limit postegresql delete reset postgres table index to next max value postgres drop and create contraint delete row psql