Search Postgresql Archives

Re: Is there a way to automatically scan a table and determine the format of data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Is there a way to automatically scan a table and determine the format of data
From: Karsten Hilbert <Karsten.Hilbert@xxxxxxx>
Date: Wed, 16 Feb 2022 11:03:36 +0100
Di_x_sposition-notification-to: Karsten.Hilbert@xxxxxxx
In-reply-to: <CA+i5JwY=k6ipf00bn3Cno_hFPvhjrFhy6=fPQxbs2eGeDkiYKA@mail.gmail.com>
Ma_x_il-followup-to: d
Re_x_turn-receipt-to: Karsten.Hilbert@xxxxxxx
References: <CA+i5JwY=k6ipf00bn3Cno_hFPvhjrFhy6=fPQxbs2eGeDkiYKA@mail.gmail.com>

Am Wed, Feb 16, 2022 at 01:27:56AM +0000 schrieb Shaozhong SHI:

> Is there a way to automatically scan a table and report the format of data
> for each column?

pg_class

But you may want to rethink the approach given that you use Python.

Karsten
-- 
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Prev by Date: Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"
Next by Date: if not exists (SELECT 1... UNION SELECT 1...)
Previous by thread: Operator % and its meaning and use
Next by thread: if not exists (SELECT 1... UNION SELECT 1...)
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux