From: | Ian Harding <iharding(at)tpchd(dot)org> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | Ashish Mahabal <aam(at)astro(dot)caltech(dot)edu>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: sybase->postgresql |
Date: | 2004-02-11 21:20:21 |
Message-ID: | 402A9C95.8060709@tpchd.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
See Also:
UNLOAD [ FROM ] TABLE [ owner. ]table-name TO filename-string
[ unload-option ... ]
unload-option :
DELIMITED BY string
| ESCAPE CHARACTER character
| ESCAPES {ON | OFF}
| FORMAT {ASCII | BCP}
| HEXADECIMAL {ON | OFF}
| ORDER {ON | OFF}
| QUOTES {ON | OFF}
Josh Berkus wrote:
>Ashish,
>
>
>
>>postgresql you said (I saw this on a list):
>>
>>
>>>Also, if you have a *running* Sybase database, conversion is a lot
>>>easier ... you can use Perl::DBI to read directly from sybase to a COPY
>>>file, and then load the COPY file into Postgres.
>>>
>>>
>>I am brand new to postgres and do have a running sybase which I wish to
>>convert. I have used perl's DBlib. However, I am not sure how to get the
>>output to copy. I will also be sending the question to postgres lists, but
>>thought I would send it to you too in case you are able to suggest
>>something.
>>
>>
>
>Easiest way? Use perl to pull from Sybase and build a COPY-formatted file.
>Then have perl log into postgres and load the file. Seems awkward, but it's
>actually *much* faster than other methods. We do this for a 1GB Sybase
>database for one client on a nightly basis; takes about 40 minutes.
>
>
>
--
It is one of the essential features of such incompetence that the person so afflicted is incapable of knowing that he is incompetent. To have such knowledge would already be to remedy a good portion of the offense. ( Miller, 1993 , p. 4)
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2004-02-11 21:27:51 | Re: Quad Xeon vs. Dual Itanium |
Previous Message | Richard Huxton | 2004-02-11 21:09:00 | Re: createdb feature request |