Postgres Pro
Downloads
Home   >   mailing lists

List all Indexes of a schema or database in CREATE syntax - Mailing list pgsql-sql

From basti
Subject List all Indexes of a schema or database in CREATE syntax
Date
Msg-id 52EBBEB1.5050808@unix-solution.de
Whole thread Raw
Responses Re: List all Indexes of a schema or database in CREATE syntax  (Julien Cigar <jcigar@ulb.ac.be>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to detect values changed in field of foreign table?
Next
From: Julien Cigar
Date:
Subject: Re: List all Indexes of a schema or database in CREATE syntax