Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UzTfw-0003Lh-VC for pgsql-sql@arkaria.postgresql.org; Wed, 17 Jul 2013 15:29:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UzTfw-0000qk-Aw for pgsql-sql@arkaria.postgresql.org; Wed, 17 Jul 2013 15:29:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UzTfv-0000qe-MH for pgsql-sql@postgresql.org; Wed, 17 Jul 2013 15:29:55 +0000 Received: from snt0-omc2-s11.snt0.hotmail.com ([65.55.90.86]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UzTfr-0006LA-RG for pgsql-sql@postgresql.org; Wed, 17 Jul 2013 15:29:55 +0000 Received: from SNT139-W9 ([65.55.90.71]) by snt0-omc2-s11.snt0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Wed, 17 Jul 2013 08:29:47 -0700 X-TMN: [LLP2Phwf31UtsVw4PaJDiJpvRnfoeV8F] X-Originating-Email: [cgourofino@hotmail.com] Message-ID: Content-Type: multipart/alternative; boundary="_93b1bb6b-66b7-400f-8752-0a6f9b4b7722_" From: Carla Goncalves To: "pgsql-sql@postgresql.org" Subject: Listing table definitions by only one command Date: Wed, 17 Jul 2013 18:29:47 +0300 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 17 Jul 2013 15:29:47.0889 (UTC) FILETIME=[78B90E10:01CE8302] X-Pg-Spam-Score: -0.4 (/) 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 --_93b1bb6b-66b7-400f-8752-0a6f9b4b7722_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I would like to list the definition of all user tables by only one command= . Is there a way to *not* show pg_catalog tables when using "\d ." in Postg= reSQL 9.1.9? Thanks. = --_93b1bb6b-66b7-400f-8752-0a6f9b4b7722_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi
I would like to list the = definition of all user tables by only one command. Is there a way to *not* = show pg_catalog tables when using "\d ." in PostgreSQL 9.1.9?

Thanks= .

= --_93b1bb6b-66b7-400f-8752-0a6f9b4b7722_--