Re: column max length / max timestamps from system tables - Mailing list pgsql-admin

From sbob
Subject Re: column max length / max timestamps from system tables
Date
Msg-id 3cf4cc46-c017-a279-dec0-c68a99836bb2@quadratum-braccas.com
Whole thread Raw
In response to Re: column max length / max timestamps from system tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses RE: column max length / max timestamps from system tables
List pgsql-admin

Unfortunately this takes hours since the table has > 500million rows

just wanted to see if there was a shorrtcut / alternate


On 6/2/21 11:13 AM, David G. Johnston wrote:

On Wed, Jun 2, 2021, 10:05 sbob <sbob@quadratum-braccas.com> wrote:
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?

No.  Just query the table directly.

David J.


pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: column max length / max timestamps from system tables
Next
From:
Date:
Subject: RE: column max length / max timestamps from system tables