Re: how many records

From: Simon Willison <cs1spw(at)bath(dot)ac(dot)uk>
To: Bryan Irvine <bryan(dot)irvine(at)kingcountyjournal(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: how many records
Date: 2003-09-10 17:26:30
Message-ID: 3F5F5EC6.9060205@bath.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Bryan Irvine wrote:

> Is there an easy way to count how many records there are?

Yes, using count(*):

select count(*) from tablename;

Hope that helps,

Simon

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Louise Cofield 2003-09-10 17:26:41 Re: phone number list
Previous Message ghaverla 2003-09-10 17:17:07 Re: phone number list