From: | Brian Horan <bhoran(at)herald(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:52:52 |
Message-ID: | 3A3A92B4.5963BF39@herald.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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
easily.
psql#> \d table_name
for a specific table
psql#> \d
for all tables
and \? for other useful stuff with backslashes.
--
,~,
v Brian Horan
/(|)\ Systems Analyst/Programmer
/( | )\ Miami Herald Publishing Company
//( | )\\ bhoran(at)herald(dot)com cell: (954) 296-7807
-----"-"-----------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2000-12-15 21:55:49 | Re: simple questions |
Previous Message | Niral Trivedi | 2000-12-15 21:45:25 | simple questions |
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2000-12-15 21:55:49 | Re: simple questions |
Previous Message | Geoff Davidson | 2000-12-15 21:48:00 | PostgreSQL, Inc. Open Letter to the PostgreSQL Global Development Project |