/
n-dimens
/
pgloader
Обзор
Документация
Войти
/
n-dimens
/
pgloader
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/pgsql/sql/list-all-indexes.sql
33 строки
1 KB
Dimitri Fontaine
Add initial support for Citus distribution from pgloader.
11 окт 2018, 00:35
11 окт 2018, 00:35
381ac9d
Код
Авторство
О чём код?
-- params: including -- filter-list-to-where-clause for including -- excluding -- filter-list-to-where-clause for excluding select n.nspname, i.relname, i.oid, rn.nspname, r.relname, indisprimary, indisunique, (select string_agg(attname, ',') from pg_attribute where attrelid = r.oid and array[attnum::integer] <@ indkey::integer[] ) as cols, pg_get_indexdef(indexrelid), c.conname, pg_get_constraintdef(c.oid) from pg_index x join pg_class i ON i.oid = x.indexrelid join pg_class r ON r.oid = x.indrelid join pg_namespace n ON n.oid = i.relnamespace join pg_namespace rn ON rn.oid = r.relnamespace left join pg_depend d on d.classid = 'pg_class'::regclass and d.objid = i.oid and d.refclassid = 'pg_constraint'::regclass and d.deptype = 'i' left join pg_constraint c ON c.oid = d.refobjid where n.nspname !~~ '^pg_' and n.nspname <> 'information_schema' ~:[~*~;and (~{~a~^~&~10t or ~})~] ~:[~*~;and (~{~a~^~&~10t and ~})~] order by n.nspname, r.relname