agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-general@lists.postgresql.org
Subject: Re: Is there a way to automatically scan a table and determine the format of data
Date: Wed, 16 Feb 2022 11:03:36 +0100
Message-ID: <YgzL+IcClGNhBr72@hermes.hilbert.loc> (raw)
In-Reply-To: <CA+i5JwY=k6ipf00bn3Cno_hFPvhjrFhy6=fPQxbs2eGeDkiYKA@mail.gmail.com>
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





view thread (3+ messages)

Message-ID: <YgzL+IcClGNhBr72@hermes.hilbert.loc>
Permalink:  ../YgzL+IcClGNhBr72@hermes.hilbert.loc/
Also on:    postgresql.org/message-id/YgzL+IcClGNhBr72@hermes.hilbert.loc

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: Karsten.Hilbert@gmx.net, pgsql-general@lists.postgresql.org
  Subject: Re: Is there a way to automatically scan a table and determine the format of data
  In-Reply-To: <YgzL+IcClGNhBr72@hermes.hilbert.loc>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox