From: | Andy Colson <andy(at)squeakycode(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: SQL Query for Foreign constraint |
Date: | 2014-03-20 21:55:08 |
Message-ID: | 532B63BC.6070300@squeakycode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey Konoplev | 2014-03-20 22:06:16 | Re: Dead rows not getting removed during vacuum |
Previous Message | Raymond O'Donnell | 2014-03-20 21:45:11 | Re: SQL Query for Foreign constraint |