> Hi,
>
> I am in process of learning psql. I'm trying to extract information
> about tables - as many details as possible. Something similar to what
> I'm used to see using Ingres RDBMS - table structure, creation date,
> number of rows, primary keys, is it journalled, etc. In Ingres in
> order to see that information I use commands 'help <tablename>' and
> more detailed version 'help table <tablename>'. Is there any postgres
> equivalent of these commands?
>
> With psql I used '\d <tablename>' and '\d+ <tablename'. None of those
> showed me what I need. See below.
>
> Thanks in advance,
> Nina
>
> eq=# \d+ c_ass \g
> Table "public.c_ass"
> Column | Type | Modifiers |
> Description
> -------------+---------------+------------------------------+---------
> ----
> arrid | character(16) | not null |
> solid | character(16) | not null |
> wt_flag | character(1) | not null default ' '::bpchar |
> res | real | |
> wt | real | |
> dist | real | |
> az | real | |
> octant | character(2) | not null default ' '::bpchar |
> mag1 | real | |
> av_mag1_flg | character(1) | not null default ' '::bpchar |
> mag1type | character(4) | not null default ' '::bpchar |
> mag1_res | real | not null default 0 |
> cphase | character(8) | not null default ' '::bpchar |
> emerang | real | |
> delta | real | |
> Has OIDs: no
>
> Ingres
> =====
>
> * help c_ass \g
> Executing . . .
>
> Name: c_ass
> Owner: dba
> Created: 2008-05-02 10:03:09
> Type: user table
> Version: II2.6
>
> Column Information:
> Key
> Column Name Type Length Nulls Defaults Seq
> arrid char 16 no no 2
> solid char 16 no no 1
> wt_flag char 1 no yes
> res float 4 yes null
> wt float 4 yes null
>
> * help table c_ass \g
> Executing . . .
>
> Name: c_ass
> Owner: dba
> Created: 2008-05-02 10:03:09
> Location: ii_database
> Type: user table
> Version: II2.6
> Page size: 8192
> Cache priority: 0
> Alter table version: 0
> Alter table totwidth: 87
> Row width: 87
> Number of rows: 3350762
> Storage structure: btree
> Compression: none
> Duplicate Rows: not allowed
> Number of pages: 83329
> Overflow data pages: 0
> Journaling: enabled
> Base table for view: no
> Optimizer statistics: none
>
> Column Information:
> Key
> Column Name Type Length Nulls Defaults Seq
> arrid char 16 no no 2
> solid char 16 no no 1
> wt_flag char 1 no yes
> res float 4 yes null
> wt float 4 yes null
>
> Secondary indexes:
> Index Name Structure Keyed On
> c_ass_idx isam arrid, solid
>
>
>
