Skip to content

Instantly share code, notes, and snippets.

@mbanck
mbanck / 0001-Address-Adobe-copyright-in-eps-file.patch
Last active December 27, 2015 07:59
Fix for PSI4 issue #26
WITH btree_index_atts AS (
SELECT nspname, relname, reltuples, relpages, indrelid, relam,
regexp_split_to_table(indkey::text, ' ')::smallint AS attnum,
indexrelid as index_oid
FROM pg_index
JOIN pg_class ON pg_class.oid=pg_index.indexrelid
JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace
JOIN pg_am ON pg_class.relam = pg_am.oid
WHERE pg_am.amname = 'btree'
),