| From: | Cho Yan Wong <pwong(at)pobox(dot)leidenuniv(dot)nl> |
|---|---|
| To: | pgsql-novice(at)postgreSQL(dot)org, pgsql-sql(at)postgreSQL(dot)org |
| Cc: | pgsql-admin(at)postgreSQL(dot)org |
| Subject: | copy probs |
| Date: | 1998-08-25 02:17:45 |
| Message-ID: | 3.0.5.32.19980825041745.00857890@pobox.leidenuniv.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-sql |
Greetings,
What's an easy way to convert a paradox database to pgsql? I have an
ascii dump of the database which I modified for the copy command. I've tried
"copy Employee from '/mydir/somewhere/db.asc' using delimiters ';';"
Everything seems to work fine except my dates are messed up. Instead of
05-19-1877 I get 05-19-31284. Actually I get 31284 or 32766 for every year.
Help?
Tempest
http://www.wi.leidenuniv.nl/~cwong/games
http://www.planetquake.com/infinity
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jose David Martinez Cuevas | 1998-08-25 15:22:14 | Re: [SQL] copy probs |
| Previous Message | G.Elangovan | 1998-08-24 16:23:50 | Maximum field in a table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas G. Lockhart | 1998-08-25 02:57:17 | Re: [GENERAL] More details on Database corruption |
| Previous Message | Sangeeta Rao | 1998-08-24 21:41:12 | Set DATESTYLE='ISO' (Postgres 6.3.2) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maarten Boekhold | 1998-08-25 07:40:58 | Re: [SQL] this one's simpler |
| Previous Message | Eric McKeown | 1998-08-25 00:06:45 | this one's simpler |