Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m4RiW-000708-QI for pgsql-odbc@arkaria.postgresql.org; Fri, 16 Jul 2021 17:33:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m4RiV-0006yQ-Pt for pgsql-odbc@arkaria.postgresql.org; Fri, 16 Jul 2021 17:33:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m4RiV-0006yH-I1 for pgsql-odbc@lists.postgresql.org; Fri, 16 Jul 2021 17:33:39 +0000 Received: from srvimsva2.dst.dk ([91.208.143.64]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m4RiR-0005Ji-0l for pgsql-odbc@postgresql.org; Fri, 16 Jul 2021 17:33:38 +0000 Received: from srvimsva2.dst.dk (unknown [127.0.0.1]) by IMSVA (Postfix) with ESMTP id 471DD104090 for ; Fri, 16 Jul 2021 19:33:31 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dst.dk; s=dmz20180119; t=1626456811; bh=GK06CHNNU6VOvLipwdOLbPCF29f1PjTyi++6JNlcN3E=; h=From:To:Date; b=VoaAp6veoib0HWQNfl8vBxi59y8lwmnb5178ED1TO/TVN7NqNVZ6znRGfiw+WYUWa 5/BBgTCRxVL9rVFQyDpN5imp58D4G+r8WNDn2yIIojoo15JZPpEc0VYMcjRvrIa+8d IANW5T9V1IglzB7yXvyBD8SlIaJ8+xntpwy0rFBQ= Received: from srvimsva2.dst.dk (unknown [127.0.0.1]) by IMSVA (Postfix) with ESMTP id 31A33104088 for ; Fri, 16 Jul 2021 19:33:31 +0200 (CEST) Received: from Sepo.dst.dk (unknown [192.168.64.12]) by srvimsva2.dst.dk (Postfix) with ESMTP for ; Fri, 16 Jul 2021 19:33:31 +0200 (CEST) Received: from srvexc9.dst.local ([172.30.32.49]) by Sepo.dst.dk (JAMES SMTP Server 2.3.2-1) with SMTP ID 701 for ; Fri, 16 Jul 2021 19:33:29 +0200 (CEST) Received: from srvexc8.dst.local (172.30.32.48) by srvexc9.dst.local (172.30.32.49) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2242.4; Fri, 16 Jul 2021 19:33:29 +0200 Received: from srvexc8.dst.local ([fe80::9df8:5de5:1bf2:8b3b]) by srvexc8.dst.local ([fe80::9df8:5de5:1bf2:8b3b%2]) with mapi id 15.01.2242.008; Fri, 16 Jul 2021 19:33:29 +0200 From: Niels Jespersen To: "pgsql-odbc@postgresql.org" Subject: Detect whether table is a partiton via SQLTable() API Thread-Topic: Detect whether table is a partiton via SQLTable() API Thread-Index: Add6aEA+LjfFJOvDQfuiHa5IVTe6Vg== Date: Fri, 16 Jul 2021 17:33:29 +0000 Message-ID: <6fb8db2e99f64b469792aeb910829fb6@dst.dk> Accept-Language: da-DK, en-US Content-Language: da-DK X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.30.33.38] Content-Type: multipart/alternative; boundary="_000_6fb8db2e99f64b469792aeb910829fb6dstdk_" MIME-Version: 1.0 X-TM-AS-GCONF: 00 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_6fb8db2e99f64b469792aeb910829fb6dstdk_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello Is it possible, in some way, to detect whether a table returned via the ODB= C SQLTable() API, is a partition? We have a need to only present base table= s and not partitions of tables. If so, from which version of the ODBC Drive= r, and how? Thank you Niels Jespersen --_000_6fb8db2e99f64b469792aeb910829fb6dstdk_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello

 

Is it possible, in some way, to detect whether a table = returned via the ODBC SQLTable() API, is a partition? We have a need to onl= y present base tables and not partitions of tables. If so, from which version of the ODBC Driver, and how? <= /p>

 

Thank you

 

Niels Jespersen

 

--_000_6fb8db2e99f64b469792aeb910829fb6dstdk_--