Re: SQL Query for Foreign constraint

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