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 1nKHA2-0001JD-Sb for pgsql-general@arkaria.postgresql.org; Wed, 16 Feb 2022 10:03:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nKHA1-0000xu-Oq for pgsql-general@arkaria.postgresql.org; Wed, 16 Feb 2022 10:03:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKHA1-0000xl-Ds for pgsql-general@lists.postgresql.org; Wed, 16 Feb 2022 10:03:45 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKH9v-00066j-DT for pgsql-general@lists.postgresql.org; Wed, 16 Feb 2022 10:03:45 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1645005818; bh=ocTZ7KAcIQ0NOa02YD2ji63QIc6vasxta8jvWe7st3w=; h=X-UI-Sender-Class:Date:From:To:Subject:References:In-Reply-To; b=BgF4Nq2tQX8jv4FH0OQmwLdD3YOOlxwG8nu4DAHMqFdsFmITYbJ9Q/zn93KPR3PNk HPIvi9fsnAb4yoESyCXiM00Ye6uZhKdqWSPRxeUMXc7BVslOnauNj51XFoILDFcMtl w+wWnQYRcaRzelquefFj/0mt5zDTleBBynNX0UZQ= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from hermes ([84.190.233.253]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1N17YY-1oI2RH3Z1u-012cBH for ; Wed, 16 Feb 2022 11:03:37 +0100 Received: from ncq by hermes with local (Exim 4.94.2) (envelope-from ) id 1nKH9s-0007ZQ-SM for pgsql-general@lists.postgresql.org; Wed, 16 Feb 2022 11:03:36 +0100 Date: Wed, 16 Feb 2022 11:03:36 +0100 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: Re: Is there a way to automatically scan a table and determine the format of data Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:hPu5DHoVWO08vK8Q0MVOTBMbzsGhawgtjKRft3sWOYiHaY+dZ21 eKhCiLpJ8Cbcy7fLewDfPRQBb6T43TsQGMoVZgBm0ID0Bt+aCNqCFEtI8fUmVCF6/NWWxby rz649XiLsnUJXkn8cIvrhTwaPzlOf7XEsnIQHLhh4UHmvmcmoxf5hIoYJUJA2QucbyKXgDM V3cVWNllp19HuT197ZjEg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:TAWz/KOHIcI=:nDgktvG8jVIQCedGynelgh YxHPMolqRsmDDL2UvBlBD1cDur+QTwdwhbcAAcKd+bpWk9f4y4RrtBS5GTl7DrNokq9bHvWx5 FqNH7ofBV/vq+EHdslwnbWqyIQx88rNimvRcV4b2boxMMb4YEwcphmjjVVpEIh1bLlTO4fwp0 /4n8a3h5qxD9dlsIC1DyzogYVL68bLDA+ZV4HLT02QTenQnjSRzi4pufG8udUWBhFY0ut1gqu vM4DINFg97jHRUPvf0oGat8q+1wYEFmDgHyIgdnyShA4bN842lXKIo9tFH1ckq8+pbJjOKGRQ brO/a1f484Jygi+IU4SJG3x35+oqwYGK6qOLKXuU/YwITHEh1HiJqn4HaLPm80y+tu1kaocEp kIT5VVkUE9gJElsHzDJTewq+8Dzo6ex5wADENeczhSouz8QoW+euMIIT5sBpW4YbMlPSlwZ90 px7E4jl+DTiRcSb/7BiwbnVh+pZRNaLiCTDvAyCNRnqQ1Lrk0ZWm1SWzts/898l7nciUPyjI6 64chJEMBOaUgsah3qsbmQoh4KyVj1zRaQJmL9UPzrgddrKOKYD/d0Iiz96Ig5FnN+AyU620fF quRXVmBuRkv0+Ht5iyFqChMJWbAKxPAS9fWo5BOzHUantEXBhy8Z0gSsb4n/DOB6vurTbpr6b jIThA68cFnHuHzfdc/HmgXQAHmbEqdOPJI/1LTMBeTSrKC9Bt94nXt8aPJIEsp7YQAgBvhXeh XOdRhBDdKXx875AL/Vv9QeW686+3BSvnOW9NwoEBTmMYCTc+qFm83/Lru3zHFcGM2f6Y0nmO5 jDx05ivzIT5qugmedF0kXYFrZXRPFKjmwauWPazEo1cNDpq/rouq1tsXwUSHcVcZ7kwTxMKmc Wg3oj7fpqrVcgyvG6x9uNJQ1lseUk3QnEQY5mqpETUNPVPGu19kj4c9pRB1PKrkNy4TzY04xI BlUWZZpIjQla8kyrzMnqzslRPdI4331KrqKk1I4keHgT53Ib7McdRCjhaQYsstdYgH4buRYvT uEEVfRKD2SpxBDFO0kCEnMaUGYQnronibmAL3fri5hTwsHLKsChDq1ysngx1QwVv/GJOqGSGX 25iDoMhkl1hL/4= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 --=20 GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B