From: | "Sokel, John" <jsokel(at)mdsi-usa(dot)com> |
---|---|
To: | pgsql-novice(at)hub(dot)org |
Cc: | Marc Zandvliet <marc(at)auroraworks(dot)com> |
Subject: | RE: Access import |
Date: | 2000-08-31 22:25:18 |
Message-ID: | CAD59D8EA8B7124894637FC44951789F496EDD@scratchy.int.mdsi-usa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I don't know if you have ODBC enabled or not, but I found this little SQL
utility that transfers data from one source into another. It saved me a
tremendous amount of time pulling my data out of an Oracle database and
pumped it right into my Postgres database. There was no messing around with
exporting and importing issues, just click and go.
The professional version is required to do DB->DB moves, but it's only $100.
John
-----Original Message-----
From: Marc Zandvliet [mailto:marc(at)auroraworks(dot)com]
Sent: Wednesday, August 30, 2000 1:43 PM
To: pgsql-novice(at)hub(dot)org
Subject: [NOVICE] Access import
I'm trying to import a small Access db into a linux-based psql database via
a delimited text file. I've set up the table to reflect the fields etc. The
last field of the database is boolean which Access exports as 0 or 1. When I
try to import I get this:
mydb=> copy new_table from '/tmp/exported.txt' using delimiters '|';
'RROR: Bad boolean external representation '1
mydb=>
I've checked the source text file and the last field doesn't have the '
before the 1.
Any suggestions? This should be straight forward right?
Thanks for any assistance,
Marc
From | Date | Subject | |
---|---|---|---|
Next Message | Warren Odom | 2000-09-01 16:02:43 | RE: sql with postgresql beginner |
Previous Message | Tom Lane | 2000-08-31 21:52:54 | Re: Failing to boot Postgres on Red Hat Linux |