From: | "Goutam Paruchuri" <gparuchuri(at)oneil(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Copy command and import - MS SQL Server to Postgres |
Date: | 2004-11-05 21:31:21 |
Message-ID: | B2C547DF42419645804F05B54290755ADC7C89@DAYTONEX.oneilinc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Iam trying to import data from ms-sql server to postgres. I export the
data which has datetime columns in sql server using BCP. I use the
following to import back into postgres.
copy tablename from 'c:\\bcpdata\\mcfa\\tablename.txt' with delimiter as
'\t'
I get the following error !!
invalid input syntax for type timestamp: ""
My input file has the timestamp value like
2004-09-30 11:31:00.000
Any clues ???
Thanks !
Goutam
Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.
From | Date | Subject | |
---|---|---|---|
Next Message | Allen Landsidel | 2004-11-05 21:48:07 | Re: Copy command and import - MS SQL Server to Postgres |
Previous Message | Devrim GUNDUZ | 2004-11-05 21:03:17 | Are there any PostgreSQL bloggers? |