[Freegis-list] FOSS able to create new PostGIS layers

[Markus Neteler]

On Feb 2, 2008 12:09 PM, Maciej Sieczka <tutey at o2.pl> wrote:
> Hi
>
> Does anybody know a FOSS which can create new PostGIS layers? Does any
> of the JUMP, Udig, gvSig, Thuban, Mezogis can? I know QGIS can't for
> sure. Or maybe there is a standalone program?

Maciek,

it seems that GRASS can do that:


# create empty map
v.in.ascii -e output=new_postgis_map

# write it out to PostGIS
v.out.ogr input=new_postgis_map type=area \
   dsn="PG:host=localhost dbname=postgis user=neteler" \
   olayer=new_postgis_map format=PostgreSQL

# check if it arrived
echo "select * from new_postgis_map" | psql postgis
 ogc_fid | wkb_geometry | cat
---------+--------------+-----
(0 rows)


Cheers
Markus