--
--  (psql): showing rowcount:
--

$ select to_char(count(*), repeat('G999',4)) as rowcount from public.x;
    rowcount         
-------------------
       232,765,672
(1 row)

#
#  (bash): dump tab-delimited file from the 9.1 instance table
#
$ time echo "copy (select * from public.x order by 1,2,3)
    to stdout delimiter E'\t'" \
  | psql -qtA -h /tmp -p 6542 -d testdb > public.x_on_testdb.txt

real    42m47.107s

#
#  (bash): dump tab-delimited file from the 9.0.3 instance table
#
$ time echo "copy (select * from public.x order by 1,2,3)
    to stdout delimiter E'\t'" \
  | psql -qtA -h localhost -p 55432 -d ms > public.x_on_ms.txt
    
real    57m49.028s

#
#  (bash): compare the two output files
#

$ time md5sum public.x_on_testdb.txt public.x_on_ms.txt
3313cba4d2a1cb14b5ba3dcc5378c33e  public.x_on_testdb.txt
3313cba4d2a1cb14b5ba3dcc5378c33e  public.x_on_ms.txt