Re: From SQLite to Postgres

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
Lists: pdxpug


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.


-- Major Contributor
Command Prompt, Inc: - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering |

In response to


Browse pdxpug by date

  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