X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1049B9FA15C for ; Thu, 11 May 2006 04:24:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 57162-08 for ; Thu, 11 May 2006 04:24:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp-out2.email.it (smtp-out2.email.it [80.247.70.37]) by postgresql.org (Postfix) with ESMTP id D29619FA29F for ; Thu, 11 May 2006 04:24:37 -0300 (ADT) Received: from 164.129.1.39 (unknown [80.247.70.11]) by smtp-out2.email.it (Email.it) with ESMTP id 301941BC082 for ; Thu, 11 May 2006 09:24:37 +0200 (CEST) Received: from Email-mailer ([164.129.1.39]) by 164.129.1.39 with HTTP (Wmail); Thu, 11 May 2006 09:24:35 +0200 Date: Thu, 11 May 2006 09:24:35 +0200 To: pgsql-admin@postgresql.org From: giuseppe.derossi@email.it Reply-To: giuseppe.derossi@email.it Subject: trobles in importing dbf file Message-ID: <0dacdc79dc4a12f8ff5b8ac7a4d7566e@164.129.1.39> X-Priority: X-Mailer: Webmail-Email.it [Mailer version 1.70] X-SenderIP: 164.129.1.39 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.997 tagged_above=0 required=5 tests=BAYES_00, FORGED_RCVD_HELO, NO_REAL_NAME, RCVD_HELO_IP_MISMATCH, RCVD_NUMERIC_HELO X-Spam-Level: *** X-Archive-Number: 200605/131 X-Sequence-Number: 21663 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