<div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px">Hi sir</span><div
style="font-family:arial,sans-serif;font-size:13px"><br/></div><div
style="font-family:arial,sans-serif;font-size:13px">CurrentlyI am using following query on mysql :</div><div
style="font-family:arial,sans-serif;font-size:13px"><br/></div><div
style="font-family:arial,sans-serif;font-size:13px">*SHOW TABLES; ---> To get list of table in a particular
db.</div><divstyle="font-family:arial,sans-serif;font-size:13px"> *
SELECT TABLE_NAME, CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME from information_schema.key_column_usage WHERE constraint_schema ='myDBName';</div><div
style="font-family:arial,sans-serif;font-size:13px"> ---> to get foreign constraint information.</div><div
style="font-family:arial,sans-serif;font-size:13px">*SHOW INDEX FROM myTableName FROM myDBName;</div><div
style="font-family:arial,sans-serif;font-size:13px"><br/></div><div
style="font-family:arial,sans-serif;font-size:13px">Iam required to get above information from postgres.</div><div
style="font-family:arial,sans-serif;font-size:13px"><br/></div><div
style="font-family:arial,sans-serif;font-size:13px">I didn't find postgres query corresponding to above mysql query to
fetchcorresponding information.</div><div style="font-family:arial,sans-serif;font-size:13px"><br /></div><div
style="font-family:arial,sans-serif;font-size:13px">PS : help me for above query in postgres.</div><div
style="font-family:arial,sans-serif;font-size:13px"><br/></div><div
style="font-family:arial,sans-serif;font-size:13px">BestRegards.</div><div
style="font-family:arial,sans-serif;font-size:13px">Bhim</div></div>