Re: Number of rows of a table

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: Raw Message | Whole Thread | 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

Browse pgsql-general by date

  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