Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Louise CofieldDate: 2003-09-10 17:26:41
Subject: Re: phone number list
Previous:From: ghaverlaDate: 2003-09-10 17:17:07
Subject: Re: phone number list

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group