Re: List all Indexes of a schema or database in CREATE syntax

On Fri, Jan 31, 2014 at 04:18:09PM +0100, basti wrote:
> Hello,
> 
> Is there a way to List all indexes of a schema or a database in CREATE
> syntax?

check pg_indexes (and the indexdef colum)

> 
> 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
> 
> 
> 
> 
> -- 
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql

-- 
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.