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(at)postgresql(dot)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.