From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
Cc: | pdxpug(at)postgresql(dot)org |
Subject: | Re: From SQLite to Postgres |
Date: | 2011-02-16 18:58:39 |
Message-ID: | 1297882719.991.2.camel@jd-desktop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
Rich:
CREATE TABLE welllog (sequence_no INTEGER, well_log INTEGER, app
TEXT, notice_of_intent INTEGER, waiver_no TEXT, date_log_rcvd
timestamp, date_log_rcvd_acc TEXT, site_type TEXT, work_type TEXT,
work_type_rmks TEXT, proposed_use TEXT, drilling_method TEXT, sc
TEXT, ha TEXT, twn TEXT, legal_twn TEXT, rng TEXT, legal_rng TEXT,
sec TEXT, sec_quarters TEXT, legal_quarters TEXT, quarters_seq TEXT,
ref TEXT, latitude float8, longitude float8, lat_long_src TEXT,
lat_long_acc TEXT, owner_current TEXT, owner_address TEXT, owner_no
TEXT, parcel_no TEXT, subdivision_name TEXT, lot_no TEXT, block_no
TEXT, well_finish_date timestamp, date_cmplt_acc TEXT, gravel_packed
TEXT, depth_seal INTEGER, depth_drilled INTEGER, depth_bedrock
INTEGER, aquifer_desc TEXT, depth_cased INTEGER, csng_diameter float8,
csng_reductions INTEGER, top_perf INTEGER, bottom_perf INTEGER,
perf_intervals INTEGER, static_wl float8, temperature float8, yield
float8, drawdown float8, hours_pumped float8, test_method TEXT,
qual_const_data TEXT, qual_lith_data TEXT, remarks TEXT,
remarks_additional TEXT, contractor_lic_no TEXT, contractor_name TEXT,
contractor_address TEXT, contractor_drlr_no INTEGER, driller_lic_no
INTEGER, source_agency TEXT, user_id TEXT, date_entry timestamp,
update_user_id TEXT, date_update timestamp, edit_status TEXT,
well_start_date timestamp, gravel_pack_top INTEGER, gravel_pack_bot
INTEGER, utm_x float8, utm_y float8);
That will create your table.
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2011-02-16 19:05:16 | Re: From SQLite to Postgres |
Previous Message | Michael Ewan | 2011-02-16 18:47:33 | Re: From SQLite to Postgres |