Re: psql: what's the SQL to compute the ratio of table sizes?

On Fri, Oct 17, 2008 at 1:30 PM, Kynn Jones <kynnjo@gmail.com> wrote:
> Suppose I have two table X and Y and I want to compute the ratio of the
> number of rows in X and the number of rows in Y.  What would be the SQL I
> could type into a psql session to get this number?
> This is an example of the recurring problem of performing arithmetic using
> the result of various calls to count(*) (or other mathematic functions).

do you need exact or approximate answers for the number of rows?