Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 12.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit

SELECT 1

create table test (id int primary key, name varchar);
create index x_in on test(name);
create index x_in2 on test(id, name);

CREATE TABLE

CREATE INDEX

CREATE INDEX

select format('drop index %I.%I;', schemaname, indexname) as qry
from pg_indexes
where schemaname not in ('pg_catalog', 'pg_toast') 
and tablename='test' 
and indexname!='test_pkey'

qry

drop index public.x_in;

drop index public.x_in2;

SELECT 2

do $$
declare
x text;
begin

x=(select string_agg(format('drop index %I.%I;', schemaname, indexname), ' ') as qry
from pg_indexes
where schemaname not in ('pg_catalog', 'pg_toast') 
and tablename='test' 
and indexname!='test_pkey');

execute x;
end $$

DO