Wes was kind enough to load the large database into Access and export a
.csv file. Now I can clean the data and table schema and move on to using
Reading Section 8.5.1 (Date/Time Imput) of the on-line 9.x manual suggests
that I can leave the date data in its original format, i.e., 7/1/1947
0:00:00. Is this correct?
If I specify the column data type as DATE rather than TIMESTAMP, will the
immaterial time portion be dropped when the file is copied into the table?
pdxpug by date
|Next:||From: Rich Shepard||Date: 2011-02-23 23:34:52|
|Subject: Changing the Primary Key Column|
|Previous:||From: Rich Shepard||Date: 2011-02-17 16:03:49|
|Subject: Re: SQLite to Postgres, II|