PostgreSQL functions to create indexes for all columns of any table.

create_indexes.sql

DROP FUNCTION create_btree_index;

CREATE OR REPLACE FUNCTION create_btree_index(schema_name text, table_name text, column_name text) RETURNS void
AS $$
BEGIN
    EXECUTE 'CREATE INDEX IF NOT EXISTS ' || table_name || '__' || column_name || '_btree ON ' || schema_name || '.' || table_name || ' USING btree (' || column_name || ');';
END;
$$ LANGUAGE plpgsql;

DROP FUNCTION create_btree_indexes_for_all_columns;

CREATE OR REPLACE FUNCTION create_btree_indexes_for_all_columns(schema__name text, table__name text) RETURNS void
AS $$
BEGIN
    PERFORM create_btree_index(table_schema, table_name, column_name) FROM information_schema.columns
    WHERE table_schema = schema__name AND table_name = table__name;
END;
$$ LANGUAGE plpgsql;

select create_btree_indexes_for_all_columns('public', 'table_name');