| From: | Christof Glaser <gcg(at)gl(dot)aser(dot)de> |
|---|---|
| To: | "Mahesh Guleria" <mahesh(at)himline(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Data Conversion |
| Date: | 2001-06-25 13:54:03 |
| Message-ID: | 01062515540301.00728@pinguin |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Monday, 25. June 2001 08:20, Mahesh Guleria wrote:
> Can be convert data from postgres to foxpro2.5??
> Is it possible?? Please help me.
I did it once, a year ago:
- import the data into MS Access
- export the data from Access as text delimited (and choose a
delimiter that doesn't occur in your data)
- run a perl or sed script to change anything that needs to be changed
(like date values or field order)
- create the table schema in PostgreSQL
- import the text files using psql and the COPY FROM command
There might be an easier way by accessing Postgres directly from Access
through ODBC. It might be slower, though :->
Hope that helps a bit.
Christof
--
gl.aser . software engineering . internet service
http://gl.aser.de/ . Planckstraße 7 . D-39104 Magdeburg
Tel. +49.391.7 44 77 10 . Fax +49.391.7 44 77 13 . Mobil 0177.77 92 84 3
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-06-25 14:59:11 | Re: RE: [ADMIN] High memory usage [PATCH] |
| Previous Message | Dave Cramer | 2001-06-25 12:11:10 | RE: [ADMIN] High memory usage [PATCH] |