[raster] Add index flag column to raster_columns

[dustymugs]

Add column to raster_columns view indicating if a raster column has an index…

The following query should be a decent starting point…

SELECT
	n.nspname AS "schema",
	c2.relname AS "table",
	c.relname AS "index",
	att.attname AS "column"
FROM pg_catalog.pg_class c
JOIN pg_catalog.pg_index i
	ON i.indexrelid = c.oid
JOIN pg_catalog.pg_class c2
	ON i.indrelid = c2.oid
JOIN pg_catalog.pg_namespace n
	ON n.oid = c.relnamespace
JOIN pg_am am
	ON c.relam = am.oid
JOIN pg_attribute att
	ON att.attrelid = c2.oid
		AND pg_catalog.format_type(att.atttypid, att.atttypmod) = 'raster'
WHERE c.relkind IN ('i')
	AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
	AND n.nspname = 'tops'
	AND am.amname = 'gist'
	AND strpos(split_part(pg_catalog.pg_get_indexdef(i.indexrelid, 0, true), ' gist ', 2), att.attname) > 0
ORDER BY 1,2,3;

[dustymugs]

Added in r11553