\d+ instinctive.leads
                                                                      Table "instinctive.leads"
      Column       |            Type             | Collation | Nullable |                      Default                       | Storage  | Stats target | Description
-------------------+-----------------------------+-----------+----------+----------------------------------------------------+----------+--------------+-------------
 leadid            | bigint                      |           | not null | nextval('instinctive.leads2_leadid_seq'::regclass) | plain    |              |
 firstname         | character varying(100)      |           |          |                                                    | extended |              |
 lastname          | character varying(50)       |           |          |                                                    | extended |              |
 address1          | character varying(250)      |           |          |                                                    | extended |              |
 address2          | character varying(250)      |           |          |                                                    | extended |              |
 city              | character varying(50)       |           |          |                                                    | extended |              |
 state             | character varying(50)       |           |          |                                                    | extended |              |
 zip               | character varying(50)       |           |          |                                                    | extended |              |
 phone1            | character varying(25)       |           |          |                                                    | extended |              |
 phone2            | character varying(25)       |           |          |                                                    | extended |              |
 phone3            | character varying(25)       |           |          |                                                    | extended |              |
 email             | character varying(50)       |           |          |                                                    | extended |              |
 inserttime        | timestamp without time zone |           |          |                                                    | plain    |              |
 sourceid          | integer                     |           |          |                                                    | plain    |              |
 assigned          | boolean                     |           |          | false                                              | plain    |              |
 sourceip          | character varying(50)       |           |          |                                                    | extended |              |
 xselect1          | character varying(50)       |           |          |                                                    | extended |              |
 xselect2          | character varying(50)       |           |          |                                                    | extended |              |
 xselect3          | character varying(50)       |           |          |                                                    | extended |              |
 xselect4          | character varying(50)       |           |          |                                                    | extended |              |
 comments          | character varying(500)      |           |          |                                                    | extended |              |
 dob               | character varying(50)       |           |          |                                                    | extended |              |
 middlename        | character varying(50)       |           |          |                                                    | extended |              |
 gender            | character varying(50)       |           |          |                                                    | extended |              |
 pipolicynum       | character varying(50)       |           |          |                                                    | extended |              |
 submitdate        | character varying(50)       |           |          |                                                    | extended |              |
 xaffid            | character varying(50)       |           |          |                                                    | extended |              |
 posturl           | text                        |           |          |                                                    | extended |              |
 leadip            | character varying(250)      |           |          |                                                    | extended |              |
 insertdate        | date                        |           | not null | ('now'::text)::date                                | plain    |              |
 processed         | boolean                     |           |          | false                                              | plain    |              |
 phone1_cell_phone | boolean                     |           |          |                                                    | plain    |              |
 phone2_cell_phone | boolean                     |           |          |                                                    | plain    |              |
 email_domain      | character varying(50)       |           |          |                                                    | extended |              |
 calculated_gender | character(1)                |           |          |                                                    | extended |              |
 nationality       | character varying(50)       |           |          |                                                    | extended |              |
 has_full_postal   | boolean                     |           |          |                                                    | plain    |              |
 campaigns         | integer[]                   |           |          |                                                    | extended |              |
 json_store        | jsonb                       |           |          |                                                    | extended |              |
Partition key: RANGE (insertdate)
Partitions: instinctive.leads_p2014_01 FOR VALUES FROM ('2014-01-01') TO ('2014-02-01'),
            instinctive.leads_p2014_02 FOR VALUES FROM ('2014-02-01') TO ('2014-03-01'),
            instinctive.leads_p2014_03 FOR VALUES FROM ('2014-03-01') TO ('2014-04-01'),
            instinctive.leads_p2014_04 FOR VALUES FROM ('2014-04-01') TO ('2014-05-01'),
            instinctive.leads_p2014_05 FOR VALUES FROM ('2014-05-01') TO ('2014-06-01'),
            instinctive.leads_p2014_06 FOR VALUES FROM ('2014-06-01') TO ('2014-07-01'),
            instinctive.leads_p2014_07 FOR VALUES FROM ('2014-07-01') TO ('2014-08-01'),
            instinctive.leads_p2014_08 FOR VALUES FROM ('2014-08-01') TO ('2014-09-01'),
            instinctive.leads_p2014_09 FOR VALUES FROM ('2014-09-01') TO ('2014-10-01')