Re: From SQLite to Postgres

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