• Home
• us.fatehi
• schemacrawler-postgresql
• 14.10.06
• source code
• EXT_INDEXES.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.

postgresql.information_schema.EXT_INDEXES.sql Maven / Gradle / Ivy

SELECT
  NULL AS INDEX_CATALOG,
  SCHEMANAME AS INDEX_SCHEMA,
  INDEXNAME AS INDEX_NAME,
  TABLENAME AS TABLE_NAME,
  CASE WHEN INDEXDEF LIKE '%UNIQUE%' THEN 'YES' ELSE 'NO' END AS IS_UNIQUE,
  INDEXDEF AS INDEX_DEFINITION
FROM
  PG_INDEXES
ORDER BY
  SCHEMANAME,
  TABLENAME,
  INDEXNAME