Postgres Pro
Downloads
Home   >   mailing lists

Re: how many records - Mailing list pgsql-novice

From Simon Willison
Subject Re: how many records
Date
Msg-id 3F5F5EC6.9060205@bath.ac.uk
Whole thread Raw
In response to how many records  (Bryan Irvine <bryan.irvine@kingcountyjournal.com>)
Responses Re: how many records  (Stuart Woodward <woodward@garage.co.jp>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Louise Cofield"
Date:
Subject: Re: how many records
Next
From: Oliver Elphick
Date:
Subject: Re: phone number list