RE: column max length / max timestamps from system tables

From: "Michel SALAIS" <msalais(at)msym(dot)fr>
To: "'sbob'" <sbob(at)quadratum-braccas(dot)com>, <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: RE: column max length / max timestamps from system tables
Date: 2021-06-02 21:44:11
Message-ID: 022e01d757f8$6d1dbb90$475932b0$@msym.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <sbob(at)quadratum-braccas(dot)com>
Envoyé : mercredi 2 juin 2021 19:05
À : pgsql-admin(at)lists(dot)postgresql(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message rammohan ganapavarapu 2021-06-02 21:45:44 Re: migrate postgresql cluster to cloudsql
Previous Message Bruce Momjian 2021-06-02 21:43:54 Re: column max length / max timestamps from system tables