copy probs - Mailing list pgsql-sql

From Cho Yan Wong
Subject copy probs
Date
Msg-id 3.0.5.32.19980825041745.00857890@pobox.leidenuniv.nl
Whole thread Raw
In response to Maximum field in a table  ("G.Elangovan " <elangog@wipinfo.soft.net>)
Responses Re: [SQL] copy probs  (Jose David Martinez Cuevas <david@morgana.estadistica.unam.mx>)
List 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


pgsql-sql by date:

Previous
From: Eric McKeown
Date:
Subject: this one's simpler
Next
From: Maarten Boekhold
Date:
Subject: Re: [SQL] this one's simpler