Re: Number of Records in a Table - Mailing list pgsql-novice

From David Olbersen
Subject Re: Number of Records in a Table
Date
Msg-id Pine.LNX.4.31.0103121812030.27230-100000@bubbles.electricutopia.net
Whole thread Raw
In response to Number of Records in a Table  (Charles Welch <caddbase@rapfire.net>)
List pgsql-novice
On Fri, 9 Mar 2001, Charles Welch wrote:

->How can you determine how many records exist in a table with out doing a
->SELECT statement and then counting the records that are read?

I assume you mean counting by hand...

SELECT COUNT( -primarykey- ) FROM table;

obviously put your pirmary key and table name where they belong.

-- Dave


pgsql-novice by date:

Previous
From: "mikhail malamud"
Date:
Subject: RE: add primary key
Next
From: "Rob Arnold"
Date:
Subject: Re: array column problem