SELECT COUNT(*) FROM <table_name>;
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
