Muito Obrigado, não sabia dessa PG_DATABASE_SIZE não, vlw pessoal!

[]'s
Fabio Galluzzo

2009/3/24 Sebastian SWC <[email protected]>

> 2009/3/24 [email protected] <[email protected]>:
> > Tenta o seguinte:
> >
> > select datname, ( select PG_DATABASE_SIZE/1024/1024 || ' MB'
> >                   from PG_DATABASE_SIZE(pd.datname)
> >                 )
> > from pg_database pd;
> >
>
> pra que tanto trabalho?
>
> select datname, pg_size_pretty(pg_database_size(datname)) from pg_database;
>
>
> --
> Atenciosamente,
> Sebastian Selau Webber Colombo
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a