-- Table: marketing_test -- DROP TABLE marketing_test; CREATE TABLE marketing_test ( odatedw character varying, osource character varying, tcode character varying, state character varying, zip character varying, mailcode character varying, pvastate character varying, dob character varying, noexch character varying, recinhse character varying, recp3 character varying, recpgvg character varying, recsweep character varying, mdmaud character varying, "domain" character varying, "cluster" character varying, age character varying, ageflag character varying, homeownr character varying, child03 character varying, child07 character varying, child12 character varying, child18 character varying, numchld character varying, income character varying, gender character varying, wealth1 character varying, hit character varying, mbcraft character varying, mbgarden character varying, mbbooks character varying, mbcolect character varying, magfaml character varying, magfem character varying, magmale character varying, pubgardn character varying, pubculin character varying, pubhlth character varying, pubdoity character varying, pubnewfn character varying, pubphoto character varying, pubopp character varying, datasrce character varying, malemili character varying, malevet character varying, vietvets character varying, wwiivets character varying, localgov character varying, stategov character varying, fedgov character varying, solp3 character varying, solih character varying, major character varying, wealth2 character varying, geocode character varying, collect1 character varying, veterans character varying, bible character varying, catlg character varying, homee character varying, pets character varying, cdplay character varying, stereo character varying, pcowners character varying, photo character varying, crafts character varying, fisher character varying, gardenin character varying, boats character varying, walker character varying, kidstuff character varying, cards character varying, plates character varying, lifesrc character varying, pepstrfl character varying, pop901 character varying, pop902 character varying, pop903 character varying, pop90c1 character varying, pop90c2 character varying, pop90c3 character varying, pop90c4 character varying, pop90c5 character varying, eth1 character varying, eth2 character varying, eth3 character varying, eth4 character varying, eth5 character varying, eth6 character varying, eth7 character varying, eth8 character varying, eth9 character varying, eth10 character varying, eth11 character varying, eth12 character varying, eth13 character varying, eth14 character varying, eth15 character varying, eth16 character varying, age901 character varying, age902 character varying, age903 character varying, age904 character varying, age905 character varying, age906 character varying, age907 character varying, chil1 character varying, chil2 character varying, chil3 character varying, agec1 character varying, agec2 character varying, agec3 character varying, agec4 character varying, agec5 character varying, agec6 character varying, agec7 character varying, chilc1 character varying, chilc2 character varying, chilc3 character varying, chilc4 character varying, chilc5 character varying, hhage1 character varying, hhage2 character varying, hhage3 character varying, hhn1 character varying, hhn2 character varying, hhn3 character varying, hhn4 character varying, hhn5 character varying, hhn6 character varying, marr1 character varying, marr2 character varying, marr3 character varying, marr4 character varying, hhp1 character varying, hhp2 character varying, dw1 character varying, dw2 character varying, dw3 character varying, dw4 character varying, dw5 character varying, dw6 character varying, dw7 character varying, dw8 character varying, dw9 character varying, hv1 character varying, hv2 character varying, hv3 character varying, hv4 character varying, hu1 character varying, hu2 character varying, hu3 character varying, hu4 character varying, hu5 character varying, hhd1 character varying, hhd2 character varying, hhd3 character varying, hhd4 character varying, hhd5 character varying, hhd6 character varying, hhd7 character varying, hhd8 character varying, hhd9 character varying, hhd10 character varying, hhd11 character varying, hhd12 character varying, ethc1 character varying, ethc2 character varying, ethc3 character varying, ethc4 character varying, ethc5 character varying, ethc6 character varying, hvp1 character varying, hvp2 character varying, hvp3 character varying, hvp4 character varying, hvp5 character varying, hvp6 character varying, hur1 character varying, hur2 character varying, rhp1 character varying, rhp2 character varying, rhp3 character varying, rhp4 character varying, hupa1 character varying, hupa2 character varying, hupa3 character varying, hupa4 character varying, hupa5 character varying, hupa6 character varying, hupa7 character varying, rp1 character varying, rp2 character varying, rp3 character varying, rp4 character varying, msa character varying, adi character varying, dma character varying, ic1 character varying, ic2 character varying, ic3 character varying, ic4 character varying, ic5 character varying, ic6 character varying, ic7 character varying, ic8 character varying, ic9 character varying, ic10 character varying, ic11 character varying, ic12 character varying, ic13 character varying, ic14 character varying, ic15 character varying, ic16 character varying, ic17 character varying, ic18 character varying, ic19 character varying, ic20 character varying, ic21 character varying, ic22 character varying, ic23 character varying, hhas1 character varying, hhas2 character varying, hhas3 character varying, hhas4 character varying, mc1 character varying, mc2 character varying, mc3 character varying, tpe1 character varying, tpe2 character varying, tpe3 character varying, tpe4 character varying, tpe5 character varying, tpe6 character varying, tpe7 character varying, tpe8 character varying, tpe9 character varying, pec1 character varying, pec2 character varying, tpe10 character varying, tpe11 character varying, tpe12 character varying, tpe13 character varying, lfc1 character varying, lfc2 character varying, lfc3 character varying, lfc4 character varying, lfc5 character varying, lfc6 character varying, lfc7 character varying, lfc8 character varying, lfc9 character varying, lfc10 character varying, occ1 character varying, occ2 character varying, occ3 character varying, occ4 character varying, occ5 character varying, occ6 character varying, occ7 character varying, occ8 character varying, occ9 character varying, occ10 character varying, occ11 character varying, occ12 character varying, occ13 character varying, eic1 character varying, eic2 character varying, eic3 character varying, eic4 character varying, eic5 character varying, eic6 character varying, eic7 character varying, eic8 character varying, eic9 character varying, eic10 character varying, eic11 character varying, eic12 character varying, eic13 character varying, eic14 character varying, eic15 character varying, eic16 character varying, oedc1 character varying, oedc2 character varying, oedc3 character varying, oedc4 character varying, oedc5 character varying, oedc6 character varying, oedc7 character varying, ec1 character varying, ec2 character varying, ec3 character varying, ec4 character varying, ec5 character varying, ec6 character varying, ec7 character varying, ec8 character varying, sec1 character varying, sec2 character varying, sec3 character varying, sec4 character varying, sec5 character varying, afc1 character varying, afc2 character varying, afc3 character varying, afc4 character varying, afc5 character varying, afc6 character varying, vc1 character varying, vc2 character varying, vc3 character varying, vc4 character varying, anc1 character varying, anc2 character varying, anc3 character varying, anc4 character varying, anc5 character varying, anc6 character varying, anc7 character varying, anc8 character varying, anc9 character varying, anc10 character varying, anc11 character varying, anc12 character varying, anc13 character varying, anc14 character varying, anc15 character varying, pobc1 character varying, pobc2 character varying, lsc1 character varying, lsc2 character varying, lsc3 character varying, lsc4 character varying, voc1 character varying, voc2 character varying, voc3 character varying, hc1 character varying, hc2 character varying, hc3 character varying, hc4 character varying, hc5 character varying, hc6 character varying, hc7 character varying, hc8 character varying, hc9 character varying, hc10 character varying, hc11 character varying, hc12 character varying, hc13 character varying, hc14 character varying, hc15 character varying, hc16 character varying, hc17 character varying, hc18 character varying, hc19 character varying, hc20 character varying, hc21 character varying, mhuc1 character varying, mhuc2 character varying, ac1 character varying, ac2 character varying, adate_2 character varying, adate_3 character varying, adate_4 character varying, adate_5 character varying, adate_6 character varying, adate_7 character varying, adate_8 character varying, adate_9 character varying, adate_10 character varying, adate_11 character varying, adate_12 character varying, adate_13 character varying, adate_14 character varying, adate_15 character varying, adate_16 character varying, adate_17 character varying, adate_18 character varying, adate_19 character varying, adate_20 character varying, adate_21 character varying, adate_22 character varying, adate_23 character varying, adate_24 character varying, rfa_2 character varying, rfa_3 character varying, rfa_4 character varying, rfa_5 character varying, rfa_6 character varying, rfa_7 character varying, rfa_8 character varying, rfa_9 character varying, rfa_10 character varying, rfa_11 character varying, rfa_12 character varying, rfa_13 character varying, rfa_14 character varying, rfa_15 character varying, rfa_16 character varying, rfa_17 character varying, rfa_18 character varying, rfa_19 character varying, rfa_20 character varying, rfa_21 character varying, rfa_22 character varying, rfa_23 character varying, rfa_24 character varying, cardprom character varying, maxadate character varying, numprom character varying, cardpm12 character varying, numprm12 character varying, rdate_3 character varying, rdate_4 character varying, rdate_5 character varying, rdate_6 character varying, rdate_7 character varying, rdate_8 character varying, rdate_9 character varying, rdate_10 character varying, rdate_11 character varying, rdate_12 character varying, rdate_13 character varying, rdate_14 character varying, rdate_15 character varying, rdate_16 character varying, rdate_17 character varying, rdate_18 character varying, rdate_19 character varying, rdate_20 character varying, rdate_21 character varying, rdate_22 character varying, rdate_23 character varying, rdate_24 character varying, ramnt_3 character varying, ramnt_4 character varying, ramnt_5 character varying, ramnt_6 character varying, ramnt_7 character varying, ramnt_8 character varying, ramnt_9 character varying, ramnt_10 character varying, ramnt_11 character varying, ramnt_12 character varying, ramnt_13 character varying, ramnt_14 character varying, ramnt_15 character varying, ramnt_16 character varying, ramnt_17 character varying, ramnt_18 character varying, ramnt_19 character varying, ramnt_20 character varying, ramnt_21 character varying, ramnt_22 character varying, ramnt_23 character varying, ramnt_24 character varying, ramntall character varying, ngiftall character varying, cardgift character varying, minramnt character varying, minrdate character varying, maxramnt character varying, maxrdate character varying, lastgift character varying, lastdate character varying, fistdate character varying, nextdate character varying, timelag character varying, avggift character varying, controln character varying, hphone_d character varying, rfa_2r character varying, rfa_2f character varying, rfa_2a character varying, mdmaud_r character varying, mdmaud_f character varying, mdmaud_a character varying, cluster2 character varying, geocode2 character varying ) WITHOUT OIDS; ALTER TABLE marketing_test OWNER TO sa;