Re: Regarding template1 database

On 4/22/2013 8:08 PM, S H wrote:
> I want to monitor externally, without changing the database. If there
> are some system queries which can tell me what are the number of
> database insertion/updation in the template1 ( including system table
> it will be helpful for me).

the system tables include the shared catalogs like pg_roles, which are
common with all databases and are modified by ALTER ROLE etc, and the
pg_catalog tables like pg_classes, which get modified when you do things
like CREATE TABLE.  it also includes system tables like
pg_stat_activity, which contain views into postgres's innards, and are
never directly modified, just queried.

so again, your request doesn't make much sense.


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast