Postgres Pro
Downloads
Home   >   mailing lists

PG query to count all objects - Mailing list pgsql-admin

From Prashant Kulkarni
Subject PG query to count all objects
Date
Msg-id CAOLrvP6na3Qddia=brN_-WtJNeuXiSPOAByaZ-03W6gr7Lr3Zw@mail.gmail.com
Whole thread Raw
Responses Re: PG query to count all objects  (Ashutosh Sharma <ashu.coek88@gmail.com>)
List pgsql-admin
Tree view
Hi Team,

Please can you help me with a query in PostgreSQL which will list the count of all objects in the database with respect (group by) object types 
( Table/ Index/Mview/Partition/Subpartition/Sequece/Lob/Procedure/Functions/..../etc)

Thanks.

pgsql-admin by date:

Previous
From: Ramakrishna Chava
Date:
Subject: Re: Can not make further subscriptions
Next
From: Ashutosh Sharma
Date:
Subject: Re: PG query to count all objects