Re: [ADMIN] simple questions

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
-----"-"-----------------------------------------