Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 5A2151FBF225 for ; Tue, 27 Dec 2011 11:29:47 -0400 (AST) Received: from sd-17937.dedibox.fr ([88.191.100.74]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RfYyH-0004wd-81 for pgsql-admin@postgresql.org; Tue, 27 Dec 2011 15:29:46 +0000 Received: from [192.168.10.3] (AMontsouris-552-1-67-164.w92-140.abo.wanadoo.fr [92.140.34.164]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id 90C003B945; Tue, 27 Dec 2011 16:30:30 +0100 (CET) Message-ID: <1324999772.3291.21.camel@localhost.localdomain> Subject: Re: listing installed modules From: Guillaume Lelarge To: Daniel =?ISO-8859-1?Q?V=E1zquez?= Cc: pgsql-admin@postgresql.org Date: Tue, 27 Dec 2011 16:29:32 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.2.2 (3.2.2-1.fc16) Mime-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201112/143 X-Sequence-Number: 38901 On Tue, 2011-12-27 at 15:55 +0100, Daniel V=C3=A1zquez wrote: > How to get a list of contrib module installed extensions on Postgresql > 8.4?? >=20 If you mean installed on the OS, it's impossible from the SQL command line. If you mean installed on your database, it's difficult to know. You need to check if a specific function / type / operator / whatever that this extension provides is available. It's difficult and error prone. That's why we now have the extensions system. Now as "in 9.1". > I see \dx command for 9.1 but not works on 8.4 >=20 Yes. That's because extensions are a new PostgreSQL object since the 9.1 release. --=20 Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org