agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: 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
Date: Fri, 31 Jan 2014 17:00:20 +0100
Message-ID: <20140131160020.GD23311@mordor.lan> (raw)
In-Reply-To: <52EBBEB1.5050808@unix-solution.de>
References: <52EBB642.5080804@unix-solution.de>
<52EBBEB1.5050808@unix-solution.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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
view thread (2+ messages)
Message-ID: <20140131160020.GD23311@mordor.lan>
Permalink: ../20140131160020.GD23311@mordor.lan/
Also on: postgresql.org/message-id/20140131160020.GD23311@mordor.lan
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jcigar@ulb.ac.be, mailinglist@unix-solution.de
Subject: Re: List all Indexes of a schema or database in CREATE syntax
In-Reply-To: <20140131160020.GD23311@mordor.lan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox