[postgis-users] MySQL->PostGIS

[Emilia Venturato]

Alle 16:52, martedì 06 settembre 2005, Stephen Woodbridge ha probabilmente 
scritto:
> 4) edit the tab separated data file so it looks like:
>
> datafile.sql
> -------------------------------
> COPY <table> FROM STDIN;
> <data from mysql stripped of any header lines>
> \.
> --------------------------------
> then load the data with psql database < datafile.sql


Sorry for my english, I know it's not good.

You can load your data (saved as .csv file) directly from PhpPgAdmin 
(http://phppgadmin.sourceforge.net) which is (in my opinion) a very good 
client for postgresql.
I found it very usefull.

Welcome in PostgreSQL/PostGIS users!

Bye
Lia


-- 
(Emi)Lia Venturato
venturato at faunalia.it
www.faunalia.it
Piazza Garibaldi 4 56025 Pontedera (PI)  Italy
Tel: (+39) 347-2770007 Fax (+39) 0587-213742