Skip site navigation (1) Skip section navigation (2)

importing from sybase

From: Vince Vielhaber <vev(at)michvhf(dot)com>
To: <pgsql-hackers(at)postgreSQL(dot)org>
Subject: importing from sybase
Date: 2001-06-05 17:26:38
Message-ID: Pine.BSF.4.30.0106051323410.88362-100000@paprika.michvhf.com (view raw or flat)
Thread:
Lists: pgsql-hackers
I'm trying to import data from a sybase bcp (tab separated dump) and am
encountering a really odd datetime type:

   Mar 27 1994 12:00:00:000AM

I've been looking in the books but haven't found anything yet and see
nothing in any of the PostgreSQL docs.  Anyone have any idea how I can
bring this data in without having to write something to read from the
sybase table and write to the postgres table?  I'd like to use copy to
keep things simple.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev(at)michvhf(dot)com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




pgsql-hackers by date

Next:From: Oleg BartunovDate: 2001-06-05 19:02:57
Subject: Re: Strange query plan
Previous:From: Tom LaneDate: 2001-06-05 16:46:12
Subject: Re: Strange query plan

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group