mesterjoco

Hy

I am new in postgre.
I would like to import tables from DBase to PostgreSql
7.3.2 .
Please help me.

Joe


__________________________________________________ ______________________
Download Yahoo! Messenger now for a chance to win Live At Knebworth DVDs
http://www.yahoo.co.uk/robbiewilliams

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

nasr.laili

* Mester J?zsef <mesterjoco@yahoo.co.uk> [031203, 09:43]:

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 Do***entation, 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) ]

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

nasr.laili

* Mester J?zsef <mesterjoco@yahoo.co.uk> [031203, 09:43]:

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 Do***entation, 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) ]

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings