pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedimporting from other dbases
7+ messages / 6 participants
[nested] [flat]
* importing from other dbases
@ 2000-05-19 17:55 Tomasz Brzezina <Tomasz.Brzezina@friends.w3.pl>
0 siblings, 1 reply; 7+ messages in thread
From: Tomasz Brzezina @ 2000-05-19 17:55 UTC (permalink / raw)
To: pgsql-interfaces
Hello pgsql-interfaces,
Is there a possibility to import external database e.g. *.dbf dBase file into Postgres base?
How to?
--
Tomasz Brzezina
FidoNet Node: 2:484/21
e-mail: brzezina@fidonet.org.pl
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: importing from other dbases
@ 2000-05-26 05:37 Max Khon <fjoe@iclub.nsu.ru>
parent: Tomasz Brzezina <Tomasz.Brzezina@friends.w3.pl>
0 siblings, 2 replies; 7+ messages in thread
From: Max Khon @ 2000-05-26 05:37 UTC (permalink / raw)
To: Tomasz Brzezina <brzezina@fidonet.org.pl>; +Cc: pgsql-interfaces
hi, there!
On Fri, 19 May 2000, Tomasz Brzezina wrote:
> Is there a possibility to import external database e.g. *.dbf dBase file into Postgres base?
> How to?
there is dbf2mysql tool on http://www.mysql.com/Contrib/dbf2mysql-1.13.tgz
I think it can be easily ported from mysql API to libpq or even ODBC
/fjoe
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: importing from other dbases
@ 2000-05-26 06:18 Michael Meskes <meskes@postgresql.org>
parent: Max Khon <fjoe@iclub.nsu.ru>
1 sibling, 1 reply; 7+ messages in thread
From: Michael Meskes @ 2000-05-26 06:18 UTC (permalink / raw)
To: Max Khon <fjoe@iclub.nsu.ru>; +Cc: Tomasz Brzezina <brzezina@fidonet.org.pl>; pgsql-interfaces
On Fri, May 26, 2000 at 12:37:50PM +0700, Max Khon wrote:
> > Is there a possibility to import external database e.g. *.dbf dBase file into Postgres base?
> > How to?
>
> there is dbf2mysql tool on http://www.mysql.com/Contrib/dbf2mysql-1.13.tgz
> I think it can be easily ported from mysql API to libpq or even ODBC
There is also a dbf2pg tool available. I do only have the Debian package
address for it, but since the original tarball is distributed too that
should suffice:
ftp://ftp.debian.org/debian/dists/potato/main/sources/misc/dbf2pg_2.0-7.deb
Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: importing from other dbases
@ 2000-05-26 08:32 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 7+ messages in thread
From: Dave Page @ 2000-05-26 08:32 UTC (permalink / raw)
To: 'Tomasz Brzezina' <brzezina@fidonet.org.pl>; +Cc: pgsql-interfaces
> -----Original Message-----
> From: Tomasz Brzezina [mailto:Tomasz.Brzezina@friends.w3.pl]
> Sent: 19 May 2000 17:55
> To: pgsql-interfaces@postgresql.org
> Subject: [INTERFACES] importing from other dbases
>
>
> Hello pgsql-interfaces,
>
> Is there a possibility to import external database e.g.
> *.dbf dBase file into Postgres base?
> How to?
pgAdmin has a db Migration Wizard - i've not tested it with a dbf file, but
if you have an ODBC driver for it it should work. pgAdmin is at:
http://www.pgadmin.freeserve.co.uk/
Regards,
Dave.
--
Disclaimer: the above is the author's personal opinion and is not the
opinion or policy of his employer or of the little green men that have been
following him all day.
http://www.vale-housing.co.uk/ - http://www.pgadmin.freeserve.co.uk/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: importing from other dbases
@ 2000-05-26 19:34 Oliver Elphick <olly@lfix.co.uk>
parent: Michael Meskes <meskes@postgresql.org>
0 siblings, 1 reply; 7+ messages in thread
From: Oliver Elphick @ 2000-05-26 19:34 UTC (permalink / raw)
To: Max Khon <fjoe@iclub.nsu.ru>; Tomasz Brzezina <brzezina@fidonet.org.pl>; pgsql-interfaces
Michael Meskes wrote:
>There is also a dbf2pg tool available. I do only have the Debian package
>address for it, but since the original tarball is distributed too that
>should suffice:
>
>ftp://ftp.debian.org/debian/dists/potato/main/sources/misc/dbf2pg_2.0-7.deb
That should be:
ftp://ftp.debian.org/debian/dists/potato/main/source/misc/dbf2sql_2.0.orig.tar.
gz
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Let nothing be done through strife or vainglory; but
in lowliness of mind let each esteem other better than
themselves." Philippians 2:3
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: importing from other dbases
@ 2000-05-26 22:36 Herbert Rabago Ambos <herbert@hindang.msuiit.edu.ph>
parent: Max Khon <fjoe@iclub.nsu.ru>
1 sibling, 0 replies; 7+ messages in thread
From: Herbert Rabago Ambos @ 2000-05-26 22:36 UTC (permalink / raw)
To: Max Khon <fjoe@iclub.nsu.ru>; +Cc: Tomasz Brzezina <brzezina@fidonet.org.pl>; pgsql-interfaces
No need to download from MYSQL site... i have a file attahce it says it
can convert dbf's to pgsql. Actually i also got it from the net. I Never
used it before, but it may help someday.
herbert
On Fri, 26 May 2000, Max Khon wrote:
> hi, there!
>
> On Fri, 19 May 2000, Tomasz Brzezina wrote:
>
> > Is there a possibility to import external database e.g. *.dbf dBase file into Postgres base?
> > How to?
>
> there is dbf2mysql tool on http://www.mysql.com/Contrib/dbf2mysql-1.13.tgz
> I think it can be easily ported from mysql API to libpq or even ODBC
>
> /fjoe
>
Attachments:
dbf2pg-3.0.tar.gz (application/octet-stream, 10.5K) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: importing from other dbases
@ 2000-05-28 11:15 Michael Meskes <meskes@postgresql.org>
parent: Oliver Elphick <olly@lfix.co.uk>
0 siblings, 0 replies; 7+ messages in thread
From: Michael Meskes @ 2000-05-28 11:15 UTC (permalink / raw)
To: pgsql-interfaces
On Fri, May 26, 2000 at 08:34:41PM +0100, Oliver Elphick wrote:
> >ftp://ftp.debian.org/debian/dists/potato/main/sources/misc/dbf2pg_2.0-7.deb
>
> That should be:
>
> ftp://ftp.debian.org/debian/dists/potato/main/source/misc/dbf2sql_2.0.orig.tar.
> gz
Oops. You're right of course. Two typos in one simple line. Arhg!
Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2000-05-28 11:15 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-19 17:55 importing from other dbases Tomasz Brzezina <Tomasz.Brzezina@friends.w3.pl>
2000-05-26 05:37 ` Max Khon <fjoe@iclub.nsu.ru>
2000-05-26 06:18 ` Michael Meskes <meskes@postgresql.org>
2000-05-26 19:34 ` Oliver Elphick <olly@lfix.co.uk>
2000-05-28 11:15 ` Michael Meskes <meskes@postgresql.org>
2000-05-26 22:36 ` Herbert Rabago Ambos <herbert@hindang.msuiit.edu.ph>
2000-05-26 08:32 RE: importing from other dbases Dave Page <dpage@vale-housing.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox