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