Re: Psql command for rowcount

On Thu, Sep 11, 2008 at 3:19 PM, Markova, Nina <nmarkova(at)nrcan(dot)gc(dot)ca> wrote:
> 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

select tablename,reltuples from pg_class inner join pg_tables on
tablename=relname where tablename !~* 'pg_*' and tablename !~*
'sql_*';

Remember that the reltuples count is an *estimate* and won't be 100%
an accurate- only a count(*) will get you that.

--
- David T. Wilson
david(dot)t(dot)wilson(at)gmail(dot)com