Show table and columns with null value and count

From: Zied Kharrat <khzied(at)gmail(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Show table and columns with null value and count
Date: 2021-08-05 14:08:58
Message-ID: CAPn-p90Bud4z_nk2arjDHZ78u7NBsEShBNZD-kJNobaN+dYi=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

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?

Many thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tchouante, Merlin 2021-08-05 14:09:41 RE: Like Command returning wrong result set
Previous Message Christophe Pettus 2021-08-05 14:05:13 Re: Like Command returning wrong result set