Re: [postgis-users] shp2pgsql -D not working properly

2014-09-19 Thread Nicolas Ribot
Hi,

-D option should appear just after shp2pgsql, not after the shape and table
parameters, no ?

Nicolas

On 19 September 2014 19:29, Rémi Cura  wrote:

> Hey list,
> I'm a bit ashamed to be stuck with a seemingly trivial problem :
> executing
> `
> /usr/lib/postgresql/9.3/bin/shp2pgsql 2_poles.shp cmm.temp_import_poles -D
> `
> output somehting like
> `
> create table
> INSERT INTO "cmm"."temp_import_poles"
> ("label","class","length_[m]","verticality","rotation_[d","gps_time_[s",geom)
> VALUES
> ('1','16','0.0','0.0','0.0','0','0101C0E018A0E0234180D8E52B5A4100E06E0F4940');
> `
>
> I'm pretty sure this isn't the postgres dump it should be .
>
> I aim to load shapfile from within the server (COPY PROGRAMM 'shp2...').
>
> Somebody has a clue about this?
>
> Cheers,
> Rémi-C
>
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] shp2pgsql -D not working properly

2014-09-21 Thread Rémi Cura
Thank you,
it was exactly this!
Cheers,
Rémi-C

2014-09-19 20:03 GMT+02:00 Nicolas Ribot :

> Hi,
>
> -D option should appear just after shp2pgsql, not after the shape and
> table parameters, no ?
>
> Nicolas
>
> On 19 September 2014 19:29, Rémi Cura  wrote:
>
>> Hey list,
>> I'm a bit ashamed to be stuck with a seemingly trivial problem :
>> executing
>> `
>> /usr/lib/postgresql/9.3/bin/shp2pgsql 2_poles.shp cmm.temp_import_poles -D
>> `
>> output somehting like
>> `
>> create table
>> INSERT INTO "cmm"."temp_import_poles"
>> ("label","class","length_[m]","verticality","rotation_[d","gps_time_[s",geom)
>> VALUES
>> ('1','16','0.0','0.0','0.0','0','0101C0E018A0E0234180D8E52B5A4100E06E0F4940');
>> `
>>
>> I'm pretty sure this isn't the postgres dump it should be .
>>
>> I aim to load shapfile from within the server (COPY PROGRAMM 'shp2...').
>>
>> Somebody has a clue about this?
>>
>> Cheers,
>> Rémi-C
>>
>> ___
>> postgis-users mailing list
>> postgis-users@lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users