Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


In response to

Responses

pdxpug by date

Next:From: Rich ShepardDate: 2011-02-16 19:05:16
Subject: Re: From SQLite to Postgres
Previous:From: Michael EwanDate: 2011-02-16 18:47:33
Subject: Re: From SQLite to Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group