I know this doesn't answer your question, but have
you considered doing it with DTS instead of BCP?
I used it recently to migrate an Access database to
PostGreSQL and it worked great. One of the big advantages is the ability to
transform the data as it is being converted.
It is also built in
Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
>>> My input file has the timestamp value like
>>> 2004-09-30 11:31:00.000
> What about the ".000" on the end? I am not able to enter that format in
> a timestamp field in 7.4.5, it is invalid.
Nonsense.
regression=# select '2004-09-30 11:31:00.000
Title: Re: [GENERAL] Copy command and import - MS SQL Server to Postgres
I tried by taking the .000
still the same issue.
WITH NULL AS '' works fine.
WITH NULL AS NULL gives an error as well.
- Goutam
From: Robert Fitzpatrick
[mailto:[EMAIL PROTECTED]Sent: Fri 11/5/2004
On Fri, 2004-11-05 at 16:48, Allen Landsidel wrote:
> On Fri, 5 Nov 2004 16:31:21 -0500, Goutam Paruchuri
> <[EMAIL PROTECTED]> wrote:
> >
> > 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
On Fri, 5 Nov 2004 16:31:21 -0500, Goutam Paruchuri
<[EMAIL PROTECTED]> wrote:
>
> 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:\\bc
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 !!
inv
