Re: trobles in importing dbf file

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(at)esncc(dot)com>
To: pgsql-admin(at)postgresql(dot)org <pgsql-admin(at)postgresql(dot)org>
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(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
>
>
>
>
>
--
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