find the number of row for each tables

From: Patrick Coulombe <11h11(at)videotron(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: find the number of row for each tables
Date: 2000-06-14 03:01:18
Message-ID: 006901bfd5ac$cf9c4740$5116c918@videotron.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Anthony E. Greene 2000-06-14 12:02:25 Re: SHOW , DESCRIBE, oh what's it called...
Previous Message D. Duccini 2000-06-13 23:25:37 Re: SHOW , DESCRIBE, oh what's it called...