Is there a feature in Postgres where we can perform a query that selects
all tables that reference a primary key?
For example if I have three tables b.main(k integer primary key, v
primary key references b.main(k), v timestamp with time zone),
primary key references b.main(k), v timestamp with time zone)
Currently I'm using a cascading type query but was curious if there was
way to perform queries using referenced keys.
The psuedo code would look something like: select all tables where
b.main.k is referenced.
The results would be rows/columns from b.main,b.foo,and b.bar.
I've searched through the Postgresql documentation, but didn't find the
solution I was looking for. Is there way to do this?
I posted this question on stackoverflow as well but received minimal
feedback, so thought I would try here as well. If interested the link is
pgsql-novice by date
|Next:||From: Josh Kupershmidt||Date: 2012-10-10 21:20:26|
|Subject: Re: check if type is valid pg type|
|Previous:||From: Tom Lane||Date: 2012-10-09 20:51:06|
|Subject: Re: Copy command-Out of memory error|