Question : how to drop a trigger in postgresql
Answered by : tanishq-vyas
DROP TRIGGER [IF EXISTS] trigger-name
ON table-name [ CASCADE | RESTRICT ];
Source : https://www.guru99.com/postgresql-trigger-create-drop.html | Last Update : Mon, 25 May 20
Question : drop function postgresql
Answered by : excited-eland-p9rysrw65uvg
DROP FUNCTION foo(signature);
Source : https://www.postgresql.org/docs/10/sql-dropfunction.html | Last Update : Tue, 26 Oct 21
Question : delete from select postgresql
Answered by : black-buffalo-q717zfpkwpk4
DELETE FROM mytable
WHERE ctid IN ( SELECT ctid FROM mytable GROUP BY s.serialId, s.valuetimestamp ORDER BY s.serialId LIMIT 10
)
Source : | Last Update : Mon, 05 Apr 21