Re: [GENERAL] Count of non-null values per table column

2015-08-15 Thread David Nelson
On Fri, Aug 14, 2015 at 9:17 PM, Ken Tanzer wrote: > On Fri, Aug 14, 2015 at 6:35 PM, David Nelson > wrote: > >> On Fri, Aug 14, 2015 at 10:00 AM, Tom Lane wrote: >> > >> > David Rowley writes: >> > > >> Tthat is the way I would do it for a table with a small number of >> columns, but these ha

Re: [GENERAL] Count of non-null values per table column

2015-08-14 Thread Ken Tanzer
On Fri, Aug 14, 2015 at 6:35 PM, David Nelson wrote: > On Fri, Aug 14, 2015 at 10:00 AM, Tom Lane wrote: > > > > David Rowley writes: > > Tthat is the way I would do it for a table with a small number of columns, > but these have several dozen so this would get tedious. Although I just > real

Re: [GENERAL] Count of non-null values per table column

2015-08-14 Thread David Nelson
On Fri, Aug 14, 2015 at 10:00 AM, Tom Lane wrote: > > David Rowley writes: > > On 15 August 2015 at 02:32, David Nelson wrote: > >> Hello list,Apologies if this has been asked before. My search only > >> turned up ways to list the total non-null values for all columns as a > >> single number. I

Re: [GENERAL] Count of non-null values per table column

2015-08-14 Thread David Nelson
On Fri, Aug 14, 2015 at 9:59 AM, John McKown wrote: > > David, > > It still came through as junk. But I reconstructed it below > > === original message === > Apologies if this has been asked before. My search only turned up ways to list the total non-null values for all columns as a single number.

Re: [GENERAL] Count of non-null values per table column

2015-08-14 Thread Tom Lane
David Rowley writes: > On 15 August 2015 at 02:32, David Nelson wrote: >> Hello list,Apologies if this has been asked before. My search only >> turned up ways to list the total non-null values for all columns as a >> single number. I want the count for each column by column. > I assume the table

Re: [GENERAL] Count of non-null values per table column

2015-08-14 Thread John McKown
David, It still came through as junk. But I reconstructed it below === original message === Apologies if this has been asked before. My search only turned up ways to list the total non-null values for all columns as a single number. I want the count for each column by column. I have inherited a

Re: [GENERAL] Count of non-null values per table column

2015-08-14 Thread David Rowley
On 15 August 2015 at 02:32, David Nelson wrote: > Hello list,Apologies if this has been asked before. My search only > turned up ways to list the total non-null values for all columns as a > single number. I want the count for each column by column.I have > inherited a database consisting of two

Re: [GENERAL] Count of non-null values per table column

2015-08-14 Thread David Nelson
table's column of that same name, for all column names in the table.Thanks> From: dlnelson77...@outlook.com> To: pgsql-general@postgresql.org> Subject: [GENERAL] Count of non-null values per table column> Date: Fri, 14 Aug 2015 14:32:36 +

[GENERAL] Count of non-null values per table column

2015-08-14 Thread David Nelson
Hello list,Apologies if this has been asked before. My search only turned up ways to list the total non-null values for all columns as a single number. I want the count for each column by column.I have inherited a database consisting of two related huge monolithic tables that lack referential i