WHERE NOT nspname LIKE 'pg%' - Excluding system tables JOIN pg_namespace AS ns ON tbl.relnamespace = ns.oid JOIN pg_class AS tbl on tbl.oid = idx.indrelid Returns table(index_id text,is_disabled text,index_name text, index_description text, index_keys text, included_columns text, filter_definition text,columns_in_tree text,columns_in_leaf text,index_type text)ДЇrom generate_subscripts(idx.indkey,1) as t(colidx)) as columns_in_tree,ДЇrom generate_subscripts(idx.indkey,1) as t(colidx)) as columns_in_leaf, Putting all that together, the following should do what you want:Д¬reate or replace function help_index(t_nspname text, t_tablename text) JOIN pg_namespace AS ns ON tbl.relnamespace = ns.oid -<< here JOIN pg_class AS tbl on tbl.oid = idx.indrelid -<< here JOIN pg_user AS U ON i.relowner = U.usesysid You need to change the joins to something like this: Your condition i.relname=t_tablename is also wrong as i.relname is the name of the index, not the name of the table you want to get the indexes for. (select string_agg(pg_get_indexdef(idx.indexrelid, colidx + 1, true), ',')ДЇrom generate_subscripts(idx.indkey,1) as t(colidx)) as index_keys, So that returns an array, not a string (text).ДЄs you you seem to want to get a list of columns for that index not an array, you need to use string_agg(): The select expression for column 5 (and 6) is: The new error message tells you (again), exactly what your problem is:ДЇinal statement returns text instead of text at column 5. The same is true for the column 10 am.amname If you look at the definition of pg_class you will see that relname is defined as type name, not text.ДЇinal statement returns name instead of text at column 3. SQL functions are a bit more picky about data types than 'regular SQL'.

Can sql server client name be changed