[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] help command pgsql2shp
From:       strk () refractions ! net
Date:       2005-10-26 8:36:24
Message-ID: 20051026083624.GA92491 () keybit ! net
[Download RAW message or body]

If you have access to backend logs enable statements logging
and see what exactly is pgsql2shp trying to use as attributes
query. Alternatively around line 53 of pgsql2shp.c set:
#define VERBOSE 3
That would explicitly print the query before sending it to backend.

--strk;

On Tue, Oct 25, 2005 at 06:30:23PM +0200, zourite@cegetel.net wrote:
> It would be great but that's not so easy
> this is my pgsql2shp version exe
> RCSID: $Id: pgsql2shp.c,v 1.74.2.4 2005/07/22 19:20:49 strk Exp $
> USAGE: pgsql2shp [<options>] <database> [<schema>.]<table>
>        pgsql2shp [<options>] <database> <query>
> 
> And this is the original command who doesn't work
> c:\PostgreSQL\8.0.3\bin>pgsql2shp -f c:\test.shp testgis 'select * from LT
> where gid = 82'
> Initializing... Querying for attributes: ERROR:  syntax error at or near
> "Select" at character 152
> 
> Even if i use -g the_geom option
> 
> Thanks
> 
> ***************************
> Vive la reunion ile intense
> Fé pété
> 
> > 	where name = 'XXX'
> >
> > you lack proper quoting
> >
> > --strk;
> >
> > On Tue, Oct 25, 2005 at 05:28:36PM +0200, zourite@cegetel.net wrote:
> >> Hello
> >> Is anyone can give me an example of pgsql2shp command with sql query in
> >> option. Is there a documentation of this function (may be i could write
> >> it).
> >> I'm looking for something like this :
> >> pgsql2shp -f c:\test.shp testgis 'select * from LT where name = XXX' but
> >> it doesn't work !
> >>
> >> Thanks
> >>
> >>
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users@postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users@postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]