From: | "Markova, Nina" <nmarkova(at)NRCan(dot)gc(dot)ca> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Psql command for rowcount |
Date: | 2008-09-11 19:19:18 |
Message-ID: | 6D8C7E015447D0428D80E9DBABA06A1E03FA8C1F@S0-OTT-X2.nrn.nrcan.gc.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2008-09-11 19:27:42 | Re: index on id and created_at |
Previous Message | Scott Marlowe | 2008-09-11 19:02:56 | Re: connection timeouts and "killing" users |