SQL Query for Foreign constraint
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
On 20/03/2014 07:48, Bhim Kumar wrote:
Hi sir
Currently I am using following query on mysql :
* SHOW TABLES; ---> To get list of table in a particular db.
Assuming you're using psql, did you take the advice you're given on
connection and type "help"?
Anyway, to see a list of tables just enter:
\d
Lots of handy backslash commands are available - \? will tell you more,
as will the fine manual:
http://www.postgresql.org/docs/9.3/static/app-psql.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 3/20/2014 4:45 PM, Raymond O'Donnell wrote:
On 20/03/2014 07:48, Bhim Kumar wrote:
Hi sir
Currently I am using following query on mysql :
* SHOW TABLES; ---> To get list of table in a particular db.
Assuming you're using psql, did you take the advice you're given on
connection and type "help"?Anyway, to see a list of tables just enter:
\d
Lots of handy backslash commands are available - \? will tell you more,
as will the fine manual:http://www.postgresql.org/docs/9.3/static/app-psql.html
Ray.
Yep, and if you are writing code, then all that info is in the
information_schema.
try:
select * from information_schema.tables
and
select * from information_schema.columns
etc.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general