SELECT table_schema,table_name,
        column_name,data_type 
   FROM information_schema.columns 
  WHERE table_schema='public' 
    AND table_name='people';