Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W9FrC-0000xf-8c for pgsql-sql@arkaria.postgresql.org; Fri, 31 Jan 2014 15:18:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W9FrB-0001BF-Kv for pgsql-sql@arkaria.postgresql.org; Fri, 31 Jan 2014 15:18:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W9FrB-0001B9-0N for pgsql-sql@postgresql.org; Fri, 31 Jan 2014 15:18:13 +0000 Received: from ikarus.unix-solution.de ([134.0.24.232]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W9Fr8-0000o1-RR for pgsql-sql@postgresql.org; Fri, 31 Jan 2014 15:18:12 +0000 Received: from p578a6f5e.dip0.t-ipconnect.de ([87.138.111.94] helo=[192.168.30.144]) by ikarus.unix-solution.de with esmtpsa (TLS1.0:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1W9Fr7-0007uI-Ud for pgsql-sql@postgresql.org; Fri, 31 Jan 2014 16:18:10 +0100 Message-ID: <52EBBEB1.5050808@unix-solution.de> Date: Fri, 31 Jan 2014 16:18:09 +0100 From: basti User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20131103 Icedove/17.0.10 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: List all Indexes of a schema or database in CREATE syntax References: <52EBB642.5080804@unix-solution.de> In-Reply-To: <52EBB642.5080804@unix-solution.de> X-Forwarded-Message-Id: <52EBB642.5080804@unix-solution.de> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.5 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org 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