Re: trobles in importing dbf file

From: "Lane Van Ingen" <lvaningen(at)esncc(dot)com>
To: <giuseppe(dot)derossi(at)email(dot)it>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: trobles in importing dbf file
Date: 2006-05-11 11:54:58
Message-ID: EKEMKEFLOMKDDLIALABICELDCKAA.lvaningen@esncc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I use 8.0.7; PostgreSQL will create tables with the number of a row (called
an OID) automatically if the config parameter called default_with_oids in
postgres.conf file is set to true. If not, it will do what your CREATE TABLE
statement says (WITH OIDS or WITHOUT OIDS); here is a sample:
CREATE TABLE alarm_active (
alarmtypeid integer NOT NULL default '0',
alarmsource integer NOT NULL default '0',
alarmstateid integer NOT NULL default '0',
messageid integer NOT NULL default '0',
ackby varchar(30) default NULL,
silencedby varchar(30) default NULL,
updatedtime timestamp(3) NOT NULL default current_timestamp(3),
alarmrfid integer NOT NULL default '0',
CONSTRAINT alarm_active_pk PRIMARY KEY (alarmtypeid,alarmsource)
) WITH OIDS;

You asked about PRIMARY KEYS. There is an example of that above, too. You
can also use ALTER TABLE to add a primary key.

I have never used dbf2pg.exe so I don't know what it adds or substracts from
the conversion process. But if it doesn't take care of the above for you, I
suppose what you could do is:
- do your import;
- set up the new table with another name, the way you want it;
- INSERT into the new table from the table that got set up by db2pg.exe
- drop the old table
- rename the new table to the old table name by using
ALTER TABLE <new table> RENAME TO <old table>

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of
giuseppe(dot)derossi(at)email(dot)it
Sent: Thursday, May 11, 2006 3:25 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] trobles in importing dbf file

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Crowson, Sarah J Ms (Contractor) Northrop Grumman 2006-05-11 15:26:16 Fatal: 2149478 (UNCLASSIFIED)
Previous Message David Bonilla 2006-05-11 11:33:18 Re: Fw: reg:logon failure