SQL Query for Foreign constraint
От
Bhim Kumar
Тема
SQL Query for Foreign constraint
Дата
Msg-id
CADzfocdYDwD5Cdir8RvAAx68wFZyQfmEMUOqdDpszCTm0S-RGw@mail.gmail.com
Список
Дерево обсуждения
SQL Query for Foreign constraint Bhim Kumar <bhimkumar33@gmail.com>
Re: SQL Query for Foreign constraint Raymond O'Donnell <rod@iol.ie>
Re: SQL Query for Foreign constraint Andy Colson <andy@squeakycode.net>
Hi sir
Currently I am using following query on mysql :
* SHOW TABLES; ---> To get list of table in a particular db.
* SELECT TABLE_NAME, CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME from information_schema.key_column_usage WHERE constraint_schema ='myDBName';
---> to get foreign constraint information.
* SHOW INDEX FROM myTableName FROM myDBName;
I am required to get above information from postgres.
I didn't find postgres query corresponding to above mysql query to fetch corresponding information.
PS : help me for above query in postgres.
Best Regards.
Bhim
В списке pgsql-general по дате отправления
