Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pulling base table name by OID?

Status
Not open for further replies.
jisoo23

jisoo23

Programmer
Jan 27, 2004
192
US
Hello all,

I'm trying to find the table names that belong to their respective foreign keys. So far, I've tried querying pg_constraint to pull all foreign keys and their respective base tables' OIDs. Then I try to query the pg_class table, which has the information I need (relname, or table name) but not sure what to query by. There is a column I could reference called "relnamespace" that takes in an OID. Does anyone know if this is the right way to pull the table name belonging to each foreign key?

Thanks,
Jisoo23
 
Status
Not open for further replies.

Similar threads

wbower34
  • Locked
  • Question
Issues with table join
Replies
2
Views
142
wbower34
wbower34
wbower34
  • Locked
  • Question
sum hours fields into another table
Replies
0
Views
123
wbower34
wbower34
dbuxton101
  • Locked
  • Question
Simple way of Exporting and Importing a Table
Replies
0
Views
133
dbuxton101
dbuxton101
jj1576
  • Locked
  • Question
Ireport question- if then else based on datatype
Replies
0
Views
112
jj1576
jj1576
MrCBofBCinTX
  • Locked
  • Question
Trigger/Function Update 1st table when update 2nd table?
Replies
2
Views
98
MrCBofBCinTX
MrCBofBCinTX

Part and Inventory Search

Sponsor

Back
Top