What does count(*) count? - Mailing list pgsql-general

From Együd Csaba
Subject What does count(*) count?
Date
Msg-id 001001c3cf7c$41256550$230a0a0a@compaq
Whole thread Raw
Responses Re: What does count(*) count?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@compaq ~
$ pg_dump -d -t t_stockchanges alumil6 > sc.dump

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

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

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

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

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

Thx,

-- Csaba


pgsql-general by date:

Previous
From: Tony
Date:
Subject: Re: Is my MySQL Gaining ?
Next
From: Bret Busby
Date:
Subject: Re: Is my MySQL Gaining ?