SELECT COUNT(*) FROM <table_name>;
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of vittorio
> Sent: Tuesday, October 18, 2005 10:29 AM
> To: pgsql-general@postgresql.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