Gmane
Favicon
From: Markus Neteler <neteler <at> osgeo.org>
Subject: Re: FOSS able to create new PostGIS layers
Newsgroups: gmane.comp.gis.freegis
Date: 2008-02-03 13:48:50 GMT (48 weeks, 5 days, 10 hours and 23 minutes ago)
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