Psql command for rowcount - Mailing list pgsql-general

From Markova, Nina
Subject Psql command for rowcount
Date
Msg-id 6D8C7E015447D0428D80E9DBABA06A1E03FA8C1F@S0-OTT-X2.nrn.nrcan.gc.ca
Whole thread Raw
Responses Re: Psql command for rowcount  ("David Wilson" <david.t.wilson@gmail.com>)
List pgsql-general

Hi,

Is there a psql or other command that I can use to list tables and their rows? All I found is this:
http://archives.postgresql.org/pgsql-hackers/2004-09/msg00876.php

The describe (\d) command (or \td+ ) doesn't show them (I  expected tuples count to be  there too) - I can only see name, type, owner.

 Schema |       Name        | Type  |  Owner  
--------+-------------------+-------+----------
 public | a0factor          | table | postgres  -----> tuples count
 public | a0factor2         | table | postgres
 public | actionlog         | table | postgres
 public | deployment_access | table | postgres
 public | fircoef           | table | postgres
 public | firfilt           | table | postgres
 public | instrument        | table | postgres
 public | netmap            | table | postgres
 public | ops_initials      | table | postgres
 public | opslog            | table | postgres
 public | opslog2actionlog  | table | postgres
 public | participation     | table | postgres
 public | pazdesc           | table | postgres
 public | pazvals           | table | postgres
 public | snetsta           | table | postgres
(15 rows)

Thanks in advance,
Nina

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: connection timeouts and "killing" users
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: index on id and created_at