[postgis-users] pgsql2shp

[Mark Cave-Ayland]

On 01/12/11 08:32, toni hernández wrote:

> Hi,
>
> I have some issues with pgsql2shp.
>
> I am using postgis 1.5.3 over postgresql 9.0 on windows.
> The database I am working with is utf8.
>
> I have several spatial tables and I want some of them to be exported to
> a shape file.
> pgsql2shp seems to be working fine but when I load the generated shape
> files, then they appear to be empty. No error thrown (on OpenJump).
>
> I have been testing it for a while and I came to realize that pgsql2shp
> does not like tables that only have one field (the spatial one). I can
> not export a table (any) with only one column but if I add a column to
> that very table (type character varying) then the exportation works fine
> and I can load the shp file perfectly
>
> At first I thought it was something about the encoding but now I am lost.
>
> Any ideas how to solve this?
> thanks

Hi Toni,

I don't suppose you've been able to try pgsql2shp from one of the 
PostGIS 2.0 pre-releases at all? It's had a fairly hefty rewrite and so 
you might find that this will have solved the issue.


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs