Date: Fri, 31 Jan 2014 17:00:20 +0100
From: Julien Cigar <jcigar@ulb.ac.be>
To: basti <mailinglist@unix-solution.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: List all Indexes of a schema or database in CREATE syntax
Message-ID: <20140131160020.GD23311@mordor.lan>
References: <52EBB642.5080804@unix-solution.de>
 <52EBBEB1.5050808@unix-solution.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <52EBBEB1.5050808@unix-solution.de>
User-Agent: Mutt/1.5.22 (2013-10-16)
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql