Re: automatic scan a table, report on data formats in columns

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: automatic scan a table, report on data formats in columns
Дата
Msg-id CAKFQuwapUTP=aaSV=-TWtxaXp=ajh9eEZjC1MX=vxBRCL6=+xw@mail.gmail.com
обсуждение исходный текст
Ответ на automatic scan a table, report on data formats in columns  (Shaozhong SHI <shishaozhong@gmail.com>)
Список pgsql-sql
Дерево обсуждения
On Mon, Feb 21, 2022 at 3:06 AM 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?


Yep, and the answer for any text column you give me is:

^.*$

If you want a classification system where you have more (already known) complex RegularExpressions and you want to choose the best fit that is also possible, and probably much more useful.

For anything else you need a better problem specification.  And I'd probably tend toward wanting to run some kind of AI system on the data - i.e., not something I'd perform in-database.

David J.

В списке pgsql-sql по дате отправления: