• Home
• net.anwiba.database
• anwiba-database-postgresql
• 1.0.154
• source code
• IsIndexedStatement.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

net.anwiba.database.postgresql.utilities.IsIndexedStatement.sql Maven / Gradle / Ivy

select count(*)
  from pg_index ki,
       pg_namespace s,
       pg_class t,
       pg_attribute a
 where ki.indrelid = t.oid
   and s.nspname = ?
   and s.oid = t.relnamespace
   and t.relname = ?
   and t.oid = a.attrelid
   and a.attname = ?
   and a.attnum = ANY (ki.indkey)