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

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Is there a way to automatically scan a table and determine the format of data
Date: 2022-02-16 01:27:56
Message-ID: CA+i5JwY=k6ipf00bn3Cno_hFPvhjrFhy6=fPQxbs2eGeDkiYKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaozhong SHI 2022-02-16 02:13:55 Is there a way to automatically scan a table and determine the format of data
Previous Message Bryn Llewellyn 2022-02-15 21:13:09 Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"

Browse pgsql-sql by date

  From Date Subject
Next Message Shaozhong SHI 2022-02-16 02:13:05 Try catch error, return data
Previous Message Ion Alberdi 2022-02-15 21:30:37 Re: Storing thousands of csv files in postgresql