Skip to content

Instantly share code, notes, and snippets.

language:python filename:setup.py filename:requirements.txt filename:Pipfile filename:pyproject.toml anyio
@qweeze
qweeze / reset-all-sequences-postgresql.sql
Created October 6, 2019 19:59
Reset all sequences in a postgresql database
-- Reset all sequences to MAX(column) value
DO
$$
DECLARE
rec RECORD;
idd integer;
BEGIN
FOR rec IN
SELECT S.relname AS seqname, C.attname AS colname, T.relname AS tblname
FROM pg_class AS S, pg_depend AS D, pg_class AS T, pg_attribute AS C