Thread: Rép. : What does count(*) count?

Rép. : What does count(*) count?

From
"Erwan DUROSELLE"
Date:
4908*2=9816
2 inserts on the same line in the dmp file?

Erwan

>>> Együd Csaba <csegyud@vnet.hu> 31/12/2003 09:58:25 >>>
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


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match