Postgres Pro
Downloads
Home   >   mailing lists

Re: automatic scan a table, report on data formats in columns - Mailing list pgsql-sql

From Jian He
Subject Re: automatic scan a table, report on data formats in columns
Date
Msg-id CAMV54g0KZKFAtG3Ppsd2BdY1x2aF7tYkRbdHxf4KtbO61ZKb0w@mail.gmail.com
Whole thread Raw
In response to automatic scan a table, report on data formats in columns  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Tree view

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@gmail.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

pgsql-sql by date:

Previous
From: Shaozhong SHI
Date:
Subject: automatic scan a table, report on data formats in columns
Next
From: "David G. Johnston"
Date:
Subject: Re: automatic scan a table, report on data formats in columns