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 1loYf3-0001Pa-58 for pgsql-admin@arkaria.postgresql.org; Wed, 02 Jun 2021 21:44:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1loYf2-0006VL-5s for pgsql-admin@arkaria.postgresql.org; Wed, 02 Jun 2021 21:44:24 +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 1loYf1-0006VC-Th for pgsql-admin@lists.postgresql.org; Wed, 02 Jun 2021 21:44:23 +0000 Received: from mout.kundenserver.de ([212.227.126.133]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1loYex-0004ff-PD for pgsql-admin@lists.postgresql.org; Wed, 02 Jun 2021 21:44:23 +0000 Received: from ANAT ([78.197.128.121]) by mrelayeu.kundenserver.de (mreue012 [212.227.15.168]) with ESMTPSA (Nemesis) id 1MV2Sk-1lvbg31e7S-00S40H; Wed, 02 Jun 2021 23:44:13 +0200 From: "Michel SALAIS" To: "'sbob'" , References: In-Reply-To: Subject: RE: column max length / max timestamps from system tables Date: Wed, 2 Jun 2021 23:44:11 +0200 Message-ID: <022e01d757f8$6d1dbb90$475932b0$@msym.fr> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQLR3QXqXCfv5y1R/RDDxLiT7yPs5KkMNdxg Content-Language: fr X-Provags-ID: V03:K1:JyEimz0zUC7c/kq/okRxwOdLAuJWfaF5jJl6N/UmdCli62P4DFW nvV6kS7accTW54Z01eSj8+FWC+ReXdh31KsYKRBijFy/Q5WTkoC8Vo12BDdSB5PPh/SAL0C 5tPQLAhEZoHrLa72AdjSDfNwhClHtdqczHbofaNLPoDsJJDM2XLrU/+K0XrNdJlDn8HUnsx lyTW7cMd7nsSPPE7kV93Q== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:yEthRStXQBI=:EF1Xv8xApux/pCGdCXbi86 PzKG4zfkWIr4kLIk3d+uO6Pf/VAtczYyCScNGNY54m39hKh/kY2KsA0u1kF5OQ4eN5eWREqnI xHfIkKjB2QZZvbxOLG0NIM/KWLhWFQxc1rLA6jj2BUaSL8XG5c6XPQQHobf/np+L0Zgsm30Ys A9cP4v7p1C5tnmpQGE7ETCgS91uZfTfUjdemKcWpSTyJSsuTHhSqQymi9+xtzI1Ohploui+tz rPehdasgBc5ax63XJQmGgFO5nEgECGinD5KrNTHauSRW77mYTfqYSgBoHKu4Oy7NJkAyfWCZS fbTYVNPVD8muPMtHm1gEE/tPPUUB1TjrWANNQjMqNo44bLBDJdxJfSH5uNiJi8O0QXzhh3cRD Nlt4VSEfiSx6ueF7LcqHcE6azyT8fEf09wGwL0QqJv3sY6FFXoftAJ0nkwSVnr/+D8mgFaIGo N9UWLihLfc6JmhbB0+6xA+lTCgJlt8KIjQZtJGT9aaCgE31+qlx5UdjiUQwgIozRUg+t6jcWo D+srsjaWc0WkpfLD7XvDdw= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, I am not sure that I understand well what you want... Have you several columns in the same table of type TIMESTAMP and you = want the max of all of them? Same thing for the length of string columns? Michel SALAIS -----Message d'origine----- De : sbob =20 Envoy=C3=A9 : mercredi 2 juin 2021 19:05 =C3=80 : pgsql-admin@lists.postgresql.org Objet : column max length / max timestamps from system tables Hi all; we need to pull the max timestamp for a set of columns and the max = string length for another set of columns. Can I get this from system = tables? If so, how up to date would it be? Thanks in advance