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
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
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
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.
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
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
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
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
+
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