Re: Show table and columns with null value and count

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Show table and columns with null value and count
Дата
Msg-id CAKFQuwbK=4FKvDXgrtWA3BeEpsCbzF4zQUxwFDmErpv8WsQ2gg@mail.gmail.com
обсуждение исходный текст
Ответ на Show table and columns with null value and count  (Zied Kharrat <khzied@gmail.com>)
Список pgsql-sql
Дерево обсуждения
On Thu, Aug 5, 2021 at 7:09 AM Zied Kharrat <khzied@gmail.com> wrote:
I have a table which contains many data.
I want to execute an sql request to show for every table, the name of the column, how many null value in this column, and total number of rows in this column.
Could you help me?
 

If you need an exact number you will need to write some dynamic SQL using the system catalogs to take inventory of the tables and columns in the database.

If you can live with estimates you can simply query the statistics that are kept by the system that it uses during query planning:
https://www.postgresql.org/docs/current/catalog-pg-statistic.html

David J.

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

Предыдущее
От: Tony Shelver
Дата:
Сообщение: Re: How to generate the order if you know the next item for each item?
Следующее
От: Rockdale Green
Дата:
Сообщение: Re: How to generate the order if you know the next item for each item?