Re: query for all values linked to a field - Mailing list pgsql-general

From anisoptera
Subject Re: query for all values linked to a field
Date
Msg-id 1323810181337-5072765.post@n5.nabble.com
Whole thread Raw
In response to Re: query for all values linked to a field  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Merlin Moncure-2 wrote
>
>
> I didn't quite parse that.    Using recursive queries, it should be
> able to pretty easily query out, given a table name, all tables that
> link to that table and the columns of the keys in the constraints
> (and, if necessary, the links from other tables to those tables).
>
> If I was looking for specific *records*, not tables and columns, I
> would probably be generating a query from the above.  (If I'm
> understanding you properly that is).
>

i'm trying to get all the values linked to a specific record, ideally with
table/column names.
so my output (given the structure i showed above) would be more like:
tblimage   image_id        image_id-value
tblimage   image_info     image_info-value
tblstack    stack_info_1  stack_info-value
tblstack    stack_info_2  stack_info-value

i didn't know about recursive queries; guess i'll start by looking that up.

thanks,
jenn
 i didn't know about recursive queries; i'll look that up.

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/query-for-all-values-linked-to-a-field-tp5072691p5072765.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: query for all values linked to a field
Next
From: Jay Levitt
Date:
Subject: Re: Controlling complexity in queries