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 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.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to