Re: really novice with Postgres !

Thanks Kevin, I'll have a look at it ...

but now, I want do 'upgrade' datas from VFP to Postgres 'step by step' and
'automatically'. I have a customer (1200 workers) who have this huge VFP app
(roads, homes, ... building from price calculation to 'work management' (hope
you understand)). This app was build in 1996. For a year, I am improving it
within VFP. He has a new 'computer scientist' who is a fan of Postgres and I
agree with him to upgrade datas to posgres. But it's a long way to go ...

For me, it's the first time I do such an upgrade but it is not the last one. I
mean : VFP client + Postgres database is a very efficient 'couple' and customers
have 'relief' when they know that datas are not in VFP !

Best Regards

--
Jean MAURICE
Grenoble - France - Europe
www.j-maurice.fr
www.atoutfox.org
www.aedtf.org

Le 02/08/2013 16:05, Kevin Salisbury a écrit :
> Jean,
>
> Have you tried pgdbf?
>
> http://pgdbf.sourceforge.net/
>
> I'm not sure you can do it easily from *within* VFP, but I know you can do it from the DBF itself and python using pgdbf on Linux. pgdbf works very nicely with VFP 9 tables and postgres 9.x - it creates postgres tables based on your DBF with postgres index(es) as needed too. The creator is responsive to questions. Please note that the python code is moving off sourceforge and onto git (which is noted on the main website as well); https://github.com/kstrauser/pgdbf
>
> A little google searching on VFP& python - there may be a way to launch python scripts using VFP;
> http://abitofscript.blogspot.com/
>
> Kevin
>