Breaking News: Grepper is joining You.com. Read the official announcement!

how to remove orphaned sequences in postgresql

Emmanuel Mahuni answered on August 22, 2022 Popularity 1/10 Helpfulness 1/10

answer how to remove orphaned sequences in postgresql

related how to remove orphaned sequences in postgresql

how to remove orphaned sequences in postgresql

Comment

SELECT string_agg('DROP SEQUENCE ' || c.oid::regclass, '; ') || ';' AS ddl
FROM   pg_class       c
LEFT   JOIN pg_depend d ON d.refobjid = c.oid
                       AND d.deptype <> 'i'
WHERE  c.relkind = 'S'
AND    d.refobjid IS NULL;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: postgresql sequences sql

Link to this answer
Share Copy Link

Contributed on Aug 22 2022

Emmanuel Mahuni

0 Answers Avg Quality 2/10

Closely Related Answers

how to remove orphaned sequences in postgresql

Comment

DO $$ DECLARE
    r text;
BEGIN
    FOR r IN (
            SELECT cl.relname
            FROM pg_class cl
            LEFT JOIN pg_namespace ns ON ns."oid" = cl.relnamespace
            LEFT JOIN pg_depend d ON d.refobjid = cl."oid" AND d.deptype <> 'i'
            WHERE ns.nspname = 'public' 
                AND cl.relkind = 'S'
                AND d.refobjid IS NULL
        ) LOOP
            -- dangerous, test before you execute!
            RAISE NOTICE '%',  -- once confident, comment this line ...
      --    EXECUTE         -- ... and uncomment this one
                'DROP SEQUENCE ' || quote_ident(r);
    END LOOP;
END $$;

Popularity 1/10 Helpfulness 8/10 Language sql

Source: stackoverflow.com

Tags: sequences sql postgresql

Link to this answer
Share Copy Link

Contributed on Aug 22 2022

Emmanuel Mahuni

0 Answers Avg Quality 2/10

how to remove orphaned sequences in postgresql

Contents

More Related Answers

how to remove orphaned sequences in postgresql

Closely Related Answers

how to remove orphaned sequences in postgresql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.