| From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
|---|---|
| To: | "vittorio" <vdemart1(at)tin(dot)it>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Number of rows of a table |
| Date: | 2005-10-18 23:30:41 |
| Message-ID: | D425483C2C5C9F49B5B7A41F8944154757D1EA@postal.corporate.connx.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
SELECT COUNT(*) FROM <table_name>;
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of vittorio
> Sent: Tuesday, October 18, 2005 10:29 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Number of rows of a table
>
> Using psql how can I ask postgresql to show the actual number of rows
of a
> table?
> Ciao
> Vittorio
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Larry Rosenman | 2005-10-18 23:32:18 | Re: PostgreSQL on Dual Processors, Dual-Core AMD Chips |
| Previous Message | Michael Glaesemann | 2005-10-18 23:23:35 | Re: Number of rows of a table |