=# \d mlg_addr
                                     Table "public.mlg_addr"
   Column    |         Type          |                         Modifiers
-------------+-----------------------+-----------------------------------------------------------
 mlg_addr_id | integer               | not null default nextval(('mlg_addr_id'::text)::regclass)
 address1    | character varying(65) |
 address2    | character varying(65) |
 city        | character varying(40) |
 state       | character varying(2)  |
 zipcode5    | character varying(5)  |
 zipcode4    | character varying(4)  |
 country     | character varying(45) |
Indexes:
    "mlg_addr_id_key" UNIQUE, btree (mlg_addr_id)
    "mlg_addr_uniq_key" UNIQUE, btree (country, zipcode5, zipcode4, address1, address2)