Request a Demo
Home   >   mailing lists

psql: what's the SQL to compute the ratio of table sizes? - Mailing list pgsql-general

From Kynn Jones
Subject psql: what's the SQL to compute the ratio of table sizes?
Date
Msg-id [email protected]
Whole thread Raw
Responses Re: psql: what's the SQL to compute the ratio of table sizes?
Re: psql: what's the SQL to compute the ratio of table sizes?
Re: psql: what's the SQL to compute the ratio of table sizes?
List pgsql-general
Tree view
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).

TIA!

Kynn

pgsql-general by date:

Previous
From: "Serge Fonville"
Date:
Subject: Re: Annoying Reply-To
Next
From: "Dave Coventry"
Date:
Subject: Re: Annoying Reply-To