Something

                                    Table "public.users"
  Column   |         Type          |                       Modifiers                        
-----------+-----------------------+--------------------------------------------------------
 userid    | integer               | not null default nextval('users_userid_seq'::regclass)
 username  | character varying(32) | 
 firstname | character varying(64) | 
 lastname  | character varying(64) | 
Indexes:
    "users_pkey" PRIMARY KEY, btree (userid)
    "users_username" btree (username)