What does count(*) count?

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: What does count(*) count?
Date: 2003-12-31 08:58:25
Message-ID: 001001c3cf7c$41256550$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
I tried to dump out a single table and just for a verification I counted the
number of 'INERT INTO' rows.
I found that count(*) results less rows than grep.
*******************

Csaba(at)compaq ~
$ pg_dump -d -t t_stockchanges alumil6 > sc.dump

*******************

alumil6=# select count(*) from t_stockchanges ;
count
-------
9816
(1 row)

*******************

Csaba(at)compaq ~
$ cat sc.dump | grep 'INSERT INTO' | wc -l
4908

*******************
What can be the reason of it?

Thx,

-- Csaba

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bret Busby 2003-12-31 09:24:02 Re: Is my MySQL Gaining ?
Previous Message Tony 2003-12-31 08:57:36 Re: Is my MySQL Gaining ?