>
> I am wondering, why I can not add the following ' A > 10' in the where
> clause i.e. 'where nspname !~* 'pg_' and A > 10'
>
> Select nspname, (SELECT count(*) as count FROM pg_tables where schemaname =
> nspname) as A
> FROM pg_namespace
> where nspname !~* 'pg_'
>
>
> what you are looking for is the having clause
Select nspname, count(1)
FROM pg_tables
where nspname !~* 'pg_'
group by nspname
having count(1) >10
best wishes
Harald
--
Harald Armin Massa www.2ndQuadrant.com
PostgreSQL Training, Services and Support
2ndQuadrant Deutschland GmbH
GF: Harald Armin Massa
Amtsgericht Stuttgart, HRB 736399