[postgis-users] OT: shp2sde on postgresql

[Yves Moisan]

Hi All,

This is slightly OT, but someone has installed ArcSDE with PostgreSQL on
a windows 2008 server and I'm trying to use shp2sde and it's not as easy
as shp2pgsql ...

Has anybody used shp2sde with such a setup ?  I'm wondering if I have to
create the destination table beforehand and if so in which schema (the
installer creates two schemas : 'public' and 'sde').  I've come across
examples using MS-SQL Server, but I'd like to know if there are
peculiarities with PostgreSQL.  I thought of using shp2pgsql to upload
directly, but none of the executables that come with PostGIS (e.g.
shp2pgsql) are installed with the SDE installer so I guess I need to use
shp2sde.

Pointers appreciated.

Cheers,

Yves