From: | Mija Lee <mija(at)scharp(dot)org> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | using system catalogs |
Date: | 2007-08-29 18:26:16 |
Message-ID: | 200708291826.l7TIQGka013833@brood2.pc.scharp.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi:
I'm definitely a postgres newbie, and was wondering about how much can be done with the system
catalogs. I'd like to a create table that links up with the pg_database catalog so I can track more
info on each database (users, associated application, status, etc).
- I assume I cannot and should not attempt to add fields to pg_database
- I have tried to create a table that uses has a reference to pg_database (datname) which it
complains about. ERROR: permission denied: "pg_database" is a system catalog_database(datname));
- I can create another table with a field that matches the datname in pg_database and try to write a
trigger that inserts into my table when a record is inserted into pg_database, but I have the feeling
that may also be
a dead end.
On a related note, I'm also trying to find the system table that links database oids with table or
schema oids, but I can't seem to find it. I know it's there somewhere, but don't see it in the doc.
thanks!
Mija
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-08-29 18:53:54 | Re: using system catalogs |
Previous Message | Alan Hodgson | 2007-08-27 20:32:15 | Re: unattended backups |