From: | Rod Taylor <pg(at)rbt(dot)ca> |
---|---|
To: | Postgresql Advocacy <pgsql-advocacy(at)postgresql(dot)org> |
Subject: | [Fwd: Re: Question] |
Date: | 2004-02-21 16:39:16 |
Message-ID: | 1077381556.31467.13.camel@jester |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
> > rbt=# select nspname, sum(relpages) from pg_class join pg_namespace n on
> > (relnamespace = n.oid) group by nspname, relnamespace having 2 > (SELECT
> > count(*) from pg_constraint where relnamespace = connamespace);
> >
> > With some effort you might be able to get the above down to a single
> > line (shorter column names, etc.).
> >
> > It takes the sum of pages used by relations in namespaces with a minimum
> > of 2 constraints.
>
> I think any query fiddling with metadata is a bad idea for a sig.
Of course. I was simply demonstrating a query class that is complicated
which many databases probably don't support (PostgreSQL didn't until
recently) and spec compliant.
--
Rod Taylor <pg [at] rbt [dot] ca>
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2004-02-21 19:25:50 | Re: Question |
Previous Message | Rod Taylor | 2004-02-21 16:37:58 | Re: Question |