 | |
How to get all tables+rows which have a foreignkey reference to arow
comp.databases.postgresql comp.databases.postgresql
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
How to get all tables+rows which have a foreignkey reference to arow -
04-29-2008
, 10:43 AM
#2
| |||
| |||
|
|
MyTable has a primary key id, and this column is used in many tables as foreign keys. How can you get all tables/rows which point to a given id? The result should be something like: tablename | foreignkey column name | primary key value of referencing table Unfortunately the third column is not always of the same type. |
you desire. Why do you want it in exactly that fashion?
Maybe a better way can be found if you tell us what you are trying to
achieve with that.
Yours,
Laurenz Albe
#3
| |||
| |||
|
|
MyTable has a primary key id, and this column is used in many tables as foreign keys. How can you get all tables/rows which point to a given id? The result should be something like: tablename | foreignkey column name | primary key value of referencing table Unfortunately the third column is not always of the same type. |
you desire. Why do you want it in exactly that fashion?
Maybe a better way can be found if you tell us what you are trying to
achieve with that.
Yours,
Laurenz Albe
#4
| |||
| |||
|
|
MyTable has a primary key id, and this column is used in many tables as foreign keys. How can you get all tables/rows which point to a given id? The result should be something like: tablename | foreignkey column name | primary key value of referencing table Unfortunately the third column is not always of the same type. |
you desire. Why do you want it in exactly that fashion?
Maybe a better way can be found if you tell us what you are trying to
achieve with that.
Yours,
Laurenz Albe
#5
| |||
| |||
|
|
MyTable has a primary key id, and this column is used in many tables as foreign keys. How can you get all tables/rows which point to a given id? The result should be something like: tablename | foreignkey column name | primary key value of referencing table Unfortunately the third column is not always of the same type. |
you desire. Why do you want it in exactly that fashion?
Maybe a better way can be found if you tell us what you are trying to
achieve with that.
Yours,
Laurenz Albe
#6
| |||
| |||
|
|
MyTable has a primary key id, and this column is used in many tables as foreign keys. How can you get all tables/rows which point to a given id? The result should be something like: tablename | foreignkey column name | primary key value of referencing table Unfortunately the third column is not always of the same type. |
you desire. Why do you want it in exactly that fashion?
Maybe a better way can be found if you tell us what you are trying to
achieve with that.
Yours,
Laurenz Albe
#7
| |||
| |||
|
|
MyTable has a primary key id, and this column is used in many tables as foreign keys. How can you get all tables/rows which point to a given id? The result should be something like: tablename | foreignkey column name | primary key value of referencing table Unfortunately the third column is not always of the same type. |
you desire. Why do you want it in exactly that fashion?
Maybe a better way can be found if you tell us what you are trying to
achieve with that.
Yours,
Laurenz Albe
#8
| |||
| |||
|
|
MyTable has a primary key id, and this column is used in many tables as foreign keys. How can you get all tables/rows which point to a given id? The result should be something like: tablename | foreignkey column name | primary key value of referencing table Unfortunately the third column is not always of the same type. |
you desire. Why do you want it in exactly that fashion?
Maybe a better way can be found if you tell us what you are trying to
achieve with that.
Yours,
Laurenz Albe
#9
| |||
| |||
|
|
MyTable has a primary key id, and this column is used in many tables as foreign keys. How can you get all tables/rows which point to a given id? The result should be something like: tablename | foreignkey column name | primary key value of referencing table Unfortunately the third column is not always of the same type. |
you desire. Why do you want it in exactly that fashion?
Maybe a better way can be found if you tell us what you are trying to
achieve with that.
Yours,
Laurenz Albe
#10
| |||
| |||
|
|
Hi, MyTable has a primary key id, and this column is used in many tables as foreign keys. How can you get all tables/rows which point to a given id? The result should be something like: tablename | foreignkey column name | primary key value of referencing table Unfortunately the third column is not always of the same type. Any hints? Thomas |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.