[postgis-users] pgsql2shp error

[Jeff Adams]

This doesn't explain or fix anything, but you could try using a temp table:

create table temp_for_export as select * from table1 where id < '20'

Then

pgsql2shp -f [path] -h [myhost] -p [port] -u [user] -P [password] [database]
temp_for_export

and see what that does.

Is there any chance your host, user or database is incorrect on the
pgsql2shp command line, so pgsql2shp is accessing a different "table1" than
you're looking at in the shell?


On Tue, Aug 10, 2010 at 6:44 AM, smas036 <sina.masoud.ansari at gmail.com>wrote:

>
> Update: The error is the same whether the column id is lower case or
> uppercase.
>
> Using single quotes 'id' produces a different error. Possibly an
> improvement:
>
> ERROR: Cannot determine geometry type (empty table).
>
> The dump works fine when a table is specified and there is no query,
> however
> there is a warning:
>
> WARNING: Cannot determine spatial reference (empty table or unknown spatial
> ref). No prj file will be generated.
>
> Any help is appreciated
>
> Sina
> --
> View this message in context:
> http://old.nabble.com/pgsql2shp-error-tp29384180p29396396.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100810/dee2b160/attachment.html>