DBT1=# \d+ customer
Table "public.customer"
Column | Type | Modifiers | Description
----------+--------------------------+-----------+-------------
c_id | integer | not null |
c_uname | character varying(20) | |
c_passwd | character varying(20) | |
c_fname | character varying(15) | |
c_lname | character varying(15) | |
c_addr_id | integer | |
c_phone | character varying(16) | |
c_email | character varying(50) | |
c_since | date | |
c_last_visit| date | |
c_login | timestamp without time zone | |
c_expiration | timestamp without time zone | |
c_discount| numeric(5,2) | |
c_balance | numeric(17,2) | |
c_ytd_pmt | numeric(17,2) | |
c_birthdate | date | |
c_data | character varying(500) | |
Indexes:
"customer_pkey" PRIMARY KEY, btree (c_id)
"i_c_birtdate" btree (c_birthdate)
"i_c_uname" btree (c_uname)
Has OIDs: no |
|