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@herald.com cell: (954) 296-7807
-----"-"-----------------------------------------