From: | Jian He <hejian(dot)mark(at)gmail(dot)com> |
---|---|
To: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
Subject: | Re: automatic scan a table, report on data formats in columns |
Date: | 2022-02-21 12:45:23 |
Message-ID: | CAMV54g0KZKFAtG3Ppsd2BdY1x2aF7tYkRbdHxf4KtbO61ZKb0w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
You first want to check a certain text pattern exists in an text column or
not. (you can use generated columns).
Not the other way around to check one text column have what kind of
pattern. If there is an pattern, it's text.
On Mon, Feb 21, 2022 at 3:36 PM Shaozhong SHI <shishaozhong(at)gmail(dot)com>
wrote:
> Is it possible to do the following?
>
> automatically scan a table of all text columns
> produce a report on data formats in columns as indicated in the following:
>
> Column A Column B Column C
> alphabetic words/phrases digits like xxxxx.xx alphanumeric
> identifiers
> City of London 5 digits followed by a iso12345
> decimal point and 2
> digits indicating precision
>
>
> It is a bit like detecting regular expression patterns automatically.
>
> Is automatically detecting something like regular expression patterns
> possible?
>
> Regards,
>
> David
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2022-02-21 16:27:12 | Re: automatic scan a table, report on data formats in columns |
Previous Message | Shaozhong SHI | 2022-02-21 10:06:20 | automatic scan a table, report on data formats in columns |