trobles in importing dbf file

From: giuseppe(dot)derossi(at)email(dot)it
To: pgsql-admin(at)postgresql(dot)org
Subject: trobles in importing dbf file
Date: 2006-05-11 07:24:35
Message-ID: 0dacdc79dc4a12f8ff5b8ac7a4d7566e@164.129.1.39
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Guys,
I'm a newbie in Postgres and hope my mail is not off topic. Well, I'm
migrating from Mysql to PostGree in order to use the postgis features. I've
some dbf files I've to import, so I've used the utility dbf2pg.exe ( I've
installed the version 8.1 in win xp env). Now is there a way to add
automatically a primary key if no, how
can I can add it after importing the table in postgres ? In mYsql an index
(the number or row) is automatically added as first column.
Sorry if the question is trivial, I didn't suspect this gap.
Is there a standard proceure to import a database mapped in a lot of dbf
files.

Thanks in advantage

--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Partecipa al concorso Best Western, ogni giorno puoi vincere un fantastico
week end da sogno!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=5096&d=20060511

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Shellam 2006-05-11 07:26:57 Re: regarding image files in DB
Previous Message Andy Shellam 2006-05-11 07:21:41 Re: Newbie question on pdAdminIII tool