| From: | Jie Liang <jliang(at)ipinc(dot)com> |
|---|---|
| To: | Niral Trivedi <niral(dot)trivedi(at)insage(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: simple questions |
| Date: | 2000-12-15 21:57:33 |
| Message-ID: | Pine.BSF.4.10.10012151356400.49677-100000@tidal.ipinc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
\d tablename
\dt --- list all tables
\dv --- list all views
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang(at)ipinc(dot)com
www.ipinc.com
On Fri, 15 Dec 2000, Niral Trivedi wrote:
> All,
>
> I have very simple two questions..
>
> How can we 'describe a table' and 'view all available tables' in postgres
> DB??
>
> I am looking for something similar to 'desc <TABLE>' and 'show tables' in
> MySQL or
> 'desc <TABLE>' and 'select * from tab' in Oracle..
>
> Thanks in advance for your help..
>
> Niral
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2000-12-15 22:00:37 | Re: simple questions |
| Previous Message | Brett W. McCoy | 2000-12-15 21:56:26 | Re: [GENERAL] simple questions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2000-12-15 22:00:37 | Re: simple questions |
| Previous Message | Brett W. McCoy | 2000-12-15 21:56:26 | Re: [GENERAL] simple questions |