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 nicolas.ri...@gmail.com:

 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 remi.c...@gmail.com 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

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 remi.c...@gmail.com 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