List all Indexes of a schema or database in CREATE syntax

From: basti <mailinglist(at)unix-solution(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: List all Indexes of a schema or database in CREATE syntax
Date: 2014-01-31 15:18:09
Message-ID: 52EBBEB1.5050808@unix-solution.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

Is there a way to List all indexes of a schema or a database in CREATE
syntax?

example for postgres database:

Tablename Indexname CREATE_syntax

pg_amop pg_amop_fam_strat_index CREATE UNIQUE ...
pg_amop pg_amop_opr_fam_index CREATE UNIQUE ...
pg_attribute pg_attribute_relid_attnam_index CREATE UNIQUE ...

Regards,
Basti

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Julien Cigar 2014-01-31 16:00:20 Re: List all Indexes of a schema or database in CREATE syntax
Previous Message Adrian Klaver 2014-01-30 15:41:41 Re: How to detect values changed in field of foreign table?