=# \d gir_outstanding Table "public.gir_outstanding" Column | Type | Modifiers ----------------+-----------------------------+----------- supp_code | text | supp_name | text | supp_brn | text | ord_no | text | due_date | timestamp without time zone | to_date | timestamp without time zone | group_code | text | brn_code | text | desc_short | text | cluster_brn | text | country_code | text | req_doc_no | integer | ops_code | text | sku | text | std_descr | text | acde_code | text | req_qty | double precision | grv_qty | double precision | skul_qty | double precision | pref_date | timestamp without time zone | skul_grv_qty | double precision | out_qty | double precision | skul_ord_cost | numeric(16,2) | out_cost | numeric | stktype_code | character varying(2) | gir_type_code | text | gir_type_descr | text | Indexes: gir_oustanding_idx1 btree (cluster_brn, sku, stktype_code) =# select count(1) from gir_outstanding; count ------- 87607 (1 row) =# \d fpp Table "public.fpp" Column | Type | Modifiers ---------+-----------------------------+----------- code | text | not null descr | text | me_dte | timestamp without time zone | cal_dte | timestamp without time zone | gl_per | integer | Indexes: fpp_pkey primary key btree (code), fpp_uidx1 unique btree (code) =# select count(1) from fpp; count ------- 92 =# \d br_prof Table "public.br_prof" Column | Type | Modifiers --------------------+-----------------------------+----------- br_cde | text | not null bprof_opened | timestamp without time zone | fpp_cde | text | bprof_avg_del_time | integer | bprof_auto_err_log | boolean | Indexes: br_prof_pkey primary key btree (br_cde) =# select count(1) from br_prof; count ------- 1 (1 row)