Hi Lane, when I've imported my first dbf table by using db2pg.exe, I tought to obtain a sql modifiable script which I could use to import the table. The table is automatically imported with the feature "without OIDS". For this reason I've to use your solution. Thanks a lot. Peraphs, because of I've to import a large database, I ought to write a procedure which performs this elaboration. My best regards Giu --------- Original Message -------- Da: Lane Van Ingen <lvaningen@xxxxxxxxx> To: pgsql-admin@xxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxx> Oggetto: RE: [ADMIN] trobles in importing dbf file Data: 11/05/06 13:57 > > > > 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@xxxxxxxxxxxxxx > [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx]On Behalf Of > giuseppe.derossi@xxxxxxxx > Sent: Thursday, May 11, 2006 3:25 AM > To: pgsql-admin@xxxxxxxxxxxxxx > 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 > > > > > -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Tutta la musica che vuoi a portata di click! Entra in www.radiosnj.com Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=5180&d=20060512
