Re: find the number of row for each tables - Mailing list pgsql-novice

From Karl F. Larsen
Subject Re: find the number of row for each tables
Date
Msg-id Pine.LNX.4.10.10006140622540.740-100000@cannac.ampr.org
Whole thread Raw
In response to find the number of row for each tables  (Patrick Coulombe <11h11@videotron.ca>)
List pgsql-novice
Try simply SELECT * from friends;


On Tue, 13 Jun 2000, Patrick Coulombe wrote:

> hi,
> here's the question : if I do this query on my database :
>
> SELECT * from friends, strangers WHERE friends.f_id = strangers.s_id AND
> friends.categorie = 1
> ----------
> 88 rows
>
> and I need to do this query to know how many rows just for my table friends
> (not both table) :
>
> SELECT * from friends WHERE friends.f_id = strangers.s_id AND
> friends.categorie = 1
> ----------
> 80 rows
>
>
> Can I just do 1 query and be able to find the number of row for each tables?
> Hope to be understand...
>
> Patrick
>
>
>
>

Yours Truly,

       - Karl F. Larsen, k5di@arrl.net  (505) 524-3303  -


pgsql-novice by date:

Previous
From: "Anthony E. Greene"
Date:
Subject: Re: SHOW , DESCRIBE, oh what's it called...
Next
From: Constantino Martins
Date:
Subject: