edbstore=> \d customers

                                          Table "edbstore.customers"

        Column        |         Type          |                           Modifiers

----------------------+-----------------------+----------------------------------------------------------------

 customerid           | integer               | not null default nextval('customers_customerid_seq'::regclass)

 firstname            | character varying(50) | not null

 lastname             | character varying(50) | not null

 address1             | character varying(50) | not null

 address2             | character varying(50) |

 city                 | character varying(50) | not null

 state                | character varying(50) |

 zip                  | integer               |

 country              | character varying(50) | not null

 region               | smallint              | not null

 email                | character varying(50) |

 phone                | character varying(50) |

 creditcardtype       | integer               | not null

 creditcard           | character varying(50) | not null

 creditcardexpiration | character varying(50) | not null

 username             | character varying(50) | not null

 password             | character varying(50) | not null

 age                  | smallint              |

 income               | integer               |

 gender               | character varying(1)  | 

<requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler">

    <lst name="defaults">

      <str name="config">data-config.xml</str>

    </lst>

  </requestHandler>

<dataConfig>

    <dataSource name="source1" type="JdbcDataSource" driver="org.postgresql.Driver" url="jdbc:postgresql://172.16.101.66:5432/edbstore" user="edbstore" password="edbstore" />

     <document>

      <entity name="file1" datasource="source1" query="SELECT * FROM edbstore.customers">

        <field column="customerid" name="id" />

        <field column="firstname" name="firstname" />

        <field column="lastname" name="lastname" />

        <field column="address1" name="address1" />

        <field column="address2" name="address2" />

        <field column="city" name="city" />

        <field column="state" name="state" />

        <field column="zip" name="zip" />

        <field column="country" name="country" />

        <field column="region" name="region" />

        <field column="email" name="email" />

        <field column="phone" name="phone" />

        <field column="creditcardtype" name="creditcardtype" />

        <field column="creditcard" name="creditcard" />

        <field column="creditcardexpiration" name="creditcardexpiration" />

        <field column="username" name="username" />

        <field column="password" name="password" />

        <field column="age" name="age" />

        <field column="income" name="income" />

        <field column="gender" name="gender" />

      </entity>

     </document>

</dataConfig> 

   <field name="id" type="string" indexed="true" stored="true" required="true" multiValued="false" /> -->

   <field name="firstname" type="string" indexed="true" stored="true" />

   <field name="lastname" type="string" indexed="true" stored="true" />

   <field name="address1" type="string" indexed="true" stored="true" />

   <field name="address2" type="string" indexed="true" stored="true" />

   <field name="city" type="string" indexed="true" stored="true" />

   <field name="state" type="string" indexed="true" stored="true" />

   <field name="zip" type="int" indexed="true" stored="true" />

   <field name="country" type="string" indexed="true" stored="true" />

   <field name="region" type="int" indexed="true" stored="true" />

   <field name="email" type="string" indexed="true" stored="true" />

   <field name="phone" type="string" indexed="true" stored="true" />

   <field name="creditcardtype" type="int" indexed="true" stored="true" />

   <field name="creditcard" type="string" indexed="true" stored="true" />

   <field name="creditcardexpiration" type="string" indexed="true" stored="true" />

   <field name="username" type="string" indexed="true" stored="true" />

   <field name="password" type="string" indexed="true" stored="true" />

   <field name="age" type="int" indexed="true" stored="true" />

   <field name="income" type="int" indexed="true" stored="true" />

   <field name="gender" type="string" indexed="true" stored="true" />