| From: | Robert Fitzpatrick <robert(at)webtent(dot)com> |
|---|---|
| To: | Allen Landsidel <alandsidel(at)gmail(dot)com> |
| Cc: | Goutam Paruchuri <gparuchuri(at)oneil(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Copy command and import - MS SQL Server to Postgres |
| Date: | 2004-11-05 22:33:58 |
| Message-ID: | 1099694038.23041.6.camel@columbus.webtent.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2004-11-05 at 16:48, Allen Landsidel wrote:
> On Fri, 5 Nov 2004 16:31:21 -0500, Goutam Paruchuri
> <gparuchuri(at)oneil(dot)com> 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:\\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
> >
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.
--
Robert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2004-11-05 22:52:56 | Re: Converting number to words |
| Previous Message | Robert Fitzpatrick | 2004-11-05 22:18:01 | Converting number to words |