On 8/9/05 10:31 AM, "TJ O'Donnell" <tjo@xxxxxxx> wrote: > 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? Good idea, but the table already exists. Try: Select * from pg_tables; And see: http://www.postgresql.org/docs/8.0/interactive/catalogs.html Sean ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
