On Sun, Dec 26, 2004 at 09:43:59 -0800,
Benjamin Smith <ben(at)charterworks(dot)net> 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 key
> 11 / Vendors / 14
> 12 / Customers / 9
>
> Can this be done?
You can use joins to get this information. To find orphaned images you
can use outer joins. To combine information from several tables in one
query you can union the queries for each table.