Thread: DBF-Files

Hi people on the list,

I have a postgresql- server installed on
my system, which i so far didnt use at all.
Now it seems that i will have to work a lot
with dbf-files (DBASE IV) that i get from
other people, which contain the production work
of a team. Is it possible to convert these
dbf-files in a simple way into postgresql readable
and so build up a pgsql-Database with them?

Thank you very much for any help.
ciao

Dieter
--

   Hi, Deieter!
  First , forgive my dirty English.
  Did your see/test postgresql-7.2.3/contrib/dbase ?
  So is many other solutions :
  What OS your use ? ;)
  If its M$ Win9X | Win2k | XP - yuor way is ODBC and write
  simplest prg on Delphi.
  Under Nix .... it's most wide quest -
  I on FreeBSD box
  first run /usr/ports/databases/dbf2mysql
  and some
  scripts to convert mysql data types and add some  my objects
  (index/triggres,stored procs)

  But finally use PHP scripts (my task  - convert plain db for my website
  postgres DB)
  IMHO php API to db VERY simple,but mayby most slowly then any
  bin utility.
 WBR
   Vic.

On Sun, Dec 01, 2002 at 11:05:13AM +0100, Dieter Maas wrote:
> Hi people on the list,
>
> I have a postgresql- server installed on
> my system, which i so far didnt use at all.
> Now it seems that i will have to work a lot
> with dbf-files (DBASE IV) that i get from
> other people, which contain the production work
> of a team. Is it possible to convert these
> dbf-files in a simple way into postgresql readable
> and so build up a pgsql-Database with them?
>
> Thank you very much for any help.
> ciao
>
> Dieter

Thanks Vic,

i have found dbf2pg in the Contrib/dbase Dir,
 I compiled the whole 7.3 package,
and it seems to work.
my dbf-tables end up to be seen in psql.

thanks a lot.

Now i have to get a tutorial and
get to fiddle with this thing.

ciao

Dieter

When I access my database, tom, from Mozilla I get a
message asking if postmaster is listening on port tom.

I did a pg-dump and noticed one of the first lines is
/connect - tom

I suppose this is the database name rather than the port?

Is there someplace I might be setting the port to "tom"?
I am using the php_lib_login_include package - it worked
fine before I moved to RedHat 8.

Thanks
Tom Hodges

On Sunday 01 December 2002 20:01, hodges@xprt.net wrote:
> When I access my database, tom, from Mozilla I get a
> message asking if postmaster is listening on port tom.
>
> I did a pg-dump and noticed one of the first lines is
> /connect - tom
>
> I suppose this is the database name rather than the port?

    No, Connect as user tom, its a multi user database to reconsruct the database
correctly \connect ensures that its correctly connected as tom.
    If you have some security settings swiched on the rebuild may fail unless you
do it as postgres.
    I'm still trying to work out if its possible to dump a database without the
\connect s and grants so that when I rebuild it else where everything still
works properly (like at home where I don't have a user rob (or what ever)...)

Peter Childs

>
> Is there someplace I might be setting the port to "tom"?
> I am using the php_lib_login_include package - it worked
> fine before I moved to RedHat 8.
>
> Thanks
> Tom Hodges
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Peter Childs <Blue.Dragon@blueyonder.co.uk> writes:
>     I'm still trying to work out if its possible to dump a database without the
> \connect s and grants so that when I rebuild it else where everything still
> works properly (like at home where I don't have a user rob (or what ever)...)

I think pg_dump -x handles this, or most of it anyway.

            regards, tom lane