[postgis-users] draw points

[Wood Brent]

> If I have a TAB DELIMITED TEXT or a excel file of a set of points with
> coordinates, how can I map this points with postgis to convert it in
> shapefile, where I can find the way to do it, thanks

Firstly, you don't need PostGIS to do this.

If you do use POstGIS, you'll need some sort of program, generally Perl or
shell script, to reformat the file into a WKT file, or some other form of file
which can be read into a PostGIS table. You'll then need to use pgsql2shp to
create the shape file. 

If all you want is the shape file, the installing & configuring of
Postgres/PostGIS and setting up the geometry table is probably overkill, and
programs like GDAL/OGR & shapelib are possibly easier. THese are able to read &
write shapefiles from a variety of other formats. You would still need to
reformat your text file into one of the appropriate formats, but overall, I
believe the operation is simpler.

If you want to manage & query your data, as well as convert it to shapefile
format then PostGIS is certainly a more appropriate approach.  


Brent Wood