Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ecHKL-0007qK-9E for pgsql-gui-dev@arkaria.postgresql.org; Thu, 18 Jan 2018 21:02:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ecHKK-0005GW-IU for pgsql-gui-dev@arkaria.postgresql.org; Thu, 18 Jan 2018 21:02:24 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ecHKK-0005GN-46 for pgsql-gui-dev@lists.postgresql.org; Thu, 18 Jan 2018 21:02:24 +0000 Received: from mail-oln040092068025.outbound.protection.outlook.com ([40.92.68.25] helo=EUR02-HE1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ecHKG-0005RU-Gu for pgsql-gui-dev@lists.postgresql.org; Thu, 18 Jan 2018 21:02:22 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=W/uBsOhb1Pps7Xa2GAgzfrR9Y1fM71CCqUQM3QJwopY=; b=XXy26o21kDDn25LAVoYUF7ZKmQysMPEdwJA0j4/E89Lgso3+7ottjsQ3e3Qt6tbDQMUyNvOoFCdwL0LD478gS4hR6eIuw8sIrrjGhD/a/nwv15N3iazFCqYJ/qrNtB9UUZw3mTfAAJ189/F9g4jmGIAiHmDBU5SkTT6/d/0fQDgWGnDCDH5h80R79eLaqnc9TJfsViBb4WP/pgT/FGAILJYFyLhLZrzrX1NAoRUuvjKPy2pXGF6MuFQC61u1sD312cSX+wZG5xym2xz0p/8xziiI3ziOjlUhFIplfs1qV4VrBbR7yEoLWbm9dGgFC54cPdi0BRBkx6rMjBTAZ0m34g== Received: from HE1EUR02FT059.eop-EUR02.prod.protection.outlook.com (10.152.10.59) by HE1EUR02HT025.eop-EUR02.prod.protection.outlook.com (10.152.11.207) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.20.428.12; Thu, 18 Jan 2018 21:02:17 +0000 Received: from HE1PR0301MB1979.eurprd03.prod.outlook.com (10.152.10.52) by HE1EUR02FT059.mail.protection.outlook.com (10.152.11.25) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.20.428.12 via Frontend Transport; Thu, 18 Jan 2018 21:02:17 +0000 Received: from HE1PR0301MB1979.eurprd03.prod.outlook.com ([fe80::8d76:3580:af02:9ba8]) by HE1PR0301MB1979.eurprd03.prod.outlook.com ([fe80::8d76:3580:af02:9ba8%14]) with mapi id 15.20.0428.014; Thu, 18 Jan 2018 21:02:17 +0000 From: legrand legrand To: "pgsql-gui-dev@lists.postgresql.org" Subject: re: pgcli Thread-Topic: pgcli Thread-Index: AQHTkJ9M2+0joUC5d02zCl1jHYHrcA== Date: Thu, 18 Jan 2018 21:02:17 +0000 Message-ID: Accept-Language: fr-FR, en-US Content-Language: fr-FR X-MS-Has-Attach: X-MS-TNEF-Correlator: x-incomingtopheadermarker: OriginalChecksum:B6669539217777A2AF77639F0D3B4EE9FABD248A0087C47554AEE3FD2A9CF46C;UpperCasedChecksum:4D5619CB75BC9C38EC258EC692C9EC93E8E6F9BA8DD8679BBEA52907DACACF9B;SizeAsReceived:6860;Count:44 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [pDe/U4PXXKJKwXF2nPFGm4/3SsbXF3vv] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;HE1EUR02HT025;6:J5ZCjvlP2vwIOPGedPYCj7wJLjv9adluP7a9oQePQeqG+pPpyDp1rSYkmk6/HmbiakjpyB0F1fDZk93xD3nT9kyNEBaIbP4GCOyRedbzPD2Jes0VwLXkid94Mts6da9bWha2WXDJ2YudPoIwUHDxAFMtCGEEp6idByOmhxLlhyusCE/216QLzBDNDB75eG0LVKdhplVn92How/dmTkD0/KAUNX8jFCUtvqyBmiB2Yp1xOfSGtSvm9wOSAGwjGf1HMoWiYXSIEmpFPGvaTic8NqeUErl6pGzDhqFWGivcTf4d9XTl1EAK/IQJjVN0hIpy+nhBrlMj+oDR/ikEH81hXe+cMsE3pQYRanZuXNMOMn0=;5:zkYGCSRcOFWZpa3e3lEcUvo0UwEoaNhuwL2eCnFpzNpEDDtLuTY1M7/9feJK9Ij70Hn8amf4OQOiaKp+zgGBo4fLGcCgD6VSTS/QXUWF2t83VfbiEuglu1L4NVLzxYnwwSfivp2w7iJDGN+lmpmBipXluUEGfGo+gALFxd5Hapk=;24:+/0Bq1rGJclmrccyqFqdyWx3fZMo71UdSqWU0Itc3dRU30a/4e3/idC/1c/oGGZMJEGUK8/XZSdzOldFGn78XNCHfxPnKVJa1WJiBLCZ9iQ=;7:dOsKEhCc+lr1J+V43kWgX3AgZys3GiFXxp+1RpIc/qx40ZFqqRRHT7mBMkYCDk+khiOO1NgvLFLAeH7/veDHOx9BwuoaVhJSMiKanETtWRHF5t3sdYUm1sfQ82aDjOvCErYQvVcAQqqA6Npt2z1Rbhz+PQbTXVG2Zq6IklAJp6x7MXQZP0hc3LInBogksy61nx5fGda+sWuZEPVyhiCO6MfuRhNTPvDTeS0JQNHtvXRic9oKgcxkB8jOGf3SegA+ x-incomingheadercount: 44 x-eopattributedmessage: 0 x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(201702061074)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031324274)(2017031323274)(2017031322404)(1603101448)(1601125374)(1701031045);SRVR:HE1EUR02HT025; x-ms-traffictypediagnostic: HE1EUR02HT025: x-ms-office365-filtering-correlation-id: b52aea60-bbec-411c-95e9-08d55eb6c1e0 x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(444000031);SRVR:HE1EUR02HT025;BCL:0;PCL:0;RULEID:(100000803101)(100110400095);SRVR:HE1EUR02HT025; x-forefront-prvs: 05568D1FF7 x-forefront-antispam-report: SFV:NSPM;SFS:(7070007)(98901004);DIR:OUT;SFP:1901;SCL:1;SRVR:HE1EUR02HT025;H:HE1PR0301MB1979.eurprd03.prod.outlook.com;FPR:;SPF:None;LANG:; spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_HE1PR0301MB1979CBD2F7B2D4D436CD096690E80HE1PR0301MB1979_" MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-Network-Message-Id: b52aea60-bbec-411c-95e9-08d55eb6c1e0 X-MS-Exchange-CrossTenant-originalarrivaltime: 18 Jan 2018 21:02:17.2104 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: HE1EUR02HT025 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_HE1PR0301MB1979CBD2F7B2D4D436CD096690E80HE1PR0301MB1979_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, > to get a list of tables in a database [...] maybe you can try with information_schema.tables > Columns query is even more complicated. Try information_schema.columns Regards PAscal --_000_HE1PR0301MB1979CBD2F7B2D4D436CD096690E80HE1PR0301MB1979_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,


> to get a list of tables in a database 
[...]
maybe you can =
try with information_schema.tables

> Columns query is even more c=
omplicated.
Try information_schema.columns

Regards
PAscal
<=
/pre>
--_000_HE1PR0301MB1979CBD2F7B2D4D436CD096690E80HE1PR0301MB1979_--