best way to reference tables - Mailing list pgsql-general

From TJ O'Donnell
Subject best way to reference tables
Date
Msg-id 42F8BE47.8080200@acm.org
Whole thread Raw
Responses Re: best way to reference tables  (Sean Davis <sdavis2@mail.nih.gov>)
Re: best way to reference tables  (Richard Huxton <dev@archonet.com>)
List pgsql-general
I have many different tables that I want to keep track of.
So, I thought of a master table with those table names in it.
But, to maintain this (suppose a table changes
its name, gets dropped) I want to have some kind of referential
integrity - the way foreign keys and constraints do.
What could I use that would disallow inserting a name into
the master table unless another table by that name already exists?
And what could ensure that a table would not be renamed or dropped
unless the master table is changed?

TJ

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Query stucked in pg_stat_activity
Next
From: Sean Davis
Date:
Subject: Re: Cross database queries