[ADMIN] Schema sizes with large objects

Hi all For auditory reasons, we need to report monthly the size of some of our databases. We have been making it with database_size, but now we have a database with diferent schemas for wich we need to know these sizes. I've seen some functions here to do this, but we have a problem with the la

Re: [ADMIN] schema sizes

Thanks, it works fine!! Morus Walter wrote: Daniel Rubio writes: Hi all! We want to obtain the size of the diferent schemas of some databases. We've installed dbsize and it works fine, but it returns the size of all the database. Exists some method to determine the size of a concrete schema? I us

Re: [ADMIN] schema sizes

Daniel Rubio writes: > Hi all! > > We want to obtain the size of the diferent schemas of some databases. > We've installed dbsize and it works fine, but it returns the size of all > the database. > Exists some method to determine the size of a concrete schema? > I use SELECT nspname, sum(relpa

[ADMIN] schema sizes

Hi all! We want to obtain the size of the diferent schemas of some databases. We've installed dbsize and it works fine, but it returns the size of all the database. Exists some method to determine the size of a concrete schema? Thanks in advance. -- ***