From: | Ennio-Sr <nasr(dot)laili(at)tin(dot)it> |
---|---|
To: | NOVICE Postgresql list <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Tables form dbase |
Date: | 2003-12-04 20:43:40 |
Message-ID: | 20031204204339.GA958@deby.ei.hnet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
* Mester J?zsef <mesterjoco(at)yahoo(dot)co(dot)uk> [031203, 09:43]:
> Hy
>
> I am new in postgre.
> I would like to import tables from DBase to PostgreSql
> 7.3.2 .
> Please help me.
I did that some time ago so I can't be very precise ;-)
Basically, you have to create a 'delimited with' *.txt file from your
dbase application. Then create a file in postgres having the same
structure of the original *.dbf plus foo fields between the real ones so
that they can be filled with the delimiters used.
As an example, if your original file has:
col1, col2, col3
the corresponding provisional-file in pg should have
col1, foo1, col2, foo2, col3, foo3
Once you have imported dbf-delimited.txt into provisional-file you can
drop the foo columns.
Have a look at PostgresQL Documentation, where you can find links to
some valuable books (readable on line), such as Bruce Momjan's and a few
others.
Hope this might help somehow.
Bye,
Ennio
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why to use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (used to say Henry Miller) ]
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Grant | 2003-12-05 04:34:46 | Re: OT: Re: Environment variables SOLVED |
Previous Message | David Rickard | 2003-12-04 20:00:20 | Oracle-Style Date Functions |