agora inbox for pgsql-sql@postgresql.orghelp / color / mirror / Atom feed
List all Indexes of a schema or database in CREATE syntax 2+ messages / 2 participants [nested] [flat]
* List all Indexes of a schema or database in CREATE syntax @ 2014-01-31 15:18 basti <mailinglist@unix-solution.de> 2014-01-31 16:00 ` Re: List all Indexes of a schema or database in CREATE syntax Julien Cigar <jcigar@ulb.ac.be> 0 siblings, 1 reply; 2+ messages in thread From: basti @ 2014-01-31 15:18 UTC (permalink / raw) To: pgsql-sql 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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: List all Indexes of a schema or database in CREATE syntax 2014-01-31 15:18 List all Indexes of a schema or database in CREATE syntax basti <mailinglist@unix-solution.de> @ 2014-01-31 16:00 ` Julien Cigar <jcigar@ulb.ac.be> 0 siblings, 0 replies; 2+ messages in thread From: Julien Cigar @ 2014-01-31 16:00 UTC (permalink / raw) To: basti <mailinglist@unix-solution.de>; +Cc: pgsql-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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-01-31 16:00 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-01-31 15:18 List all Indexes of a schema or database in CREATE syntax basti <mailinglist@unix-solution.de> 2014-01-31 16:00 ` Julien Cigar <jcigar@ulb.ac.be>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox