Re: [GENERAL] Tracking back foreign keys?

2004-12-30 Thread Bruno Wolff III
On Sun, Dec 26, 2004 at 09:43:59 -0800, Benjamin Smith <[EMAIL PROTECTED]> wrote: > > Something like > > Select pg_table.name from pg_table where pg_field references images.id > > ? > > How else do I put it? The output I'd like would be something like > images.id / tablename / table.primary

[GENERAL] Tracking back foreign keys?

2004-12-30 Thread Benjamin Smith
In one of my apps, I have an "images manager" that's become unmanageable. I'd like to be able to easily track key dependencies. Let's say I have a set of tables like this: create table Customers ( id serial unique not null primary key, name varchar not null, address varchar not null image i