[postgis-users] Error using pgsql2shp

[strk at refractions.net]

pgsql2shp sets database name using PGDATABASE environment
variable. If win has its own way of specifying
this info in the environment do it manually before invoking pgsql2shp.
See sources for more informations.

--strk;

On Wed, Jun 14, 2006 at 03:17:05PM -0600, Bruce Rindahl wrote:
> Ah if it were only possible.  Clients pay the bills.
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> strk at refractions.net
> Sent: Wednesday, June 14, 2006 3:16 PM
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] Error using pgsql2shp
> 
> On Wed, Jun 14, 2006 at 03:08:49PM -0600, Bruce Rindahl wrote:
> > I am trying to convert a PostgreSQL/PostGIS table to a shapefile.  The
> table
> > looks fine and the geometry is good based on a web application.  PostGIS
> > version 1.1.2 and the RCSID for pgsql2shp is:
> > $Id: pgsql2shp.c,v 1.84 2006/04/18 14:09:28 strk Exp $
> > 
> > My command line is:
> > pgsql2shp -f test.shp DWR dwr_gis
> > 
> > where the database is DWR and the table is dwr_gis
> > 
> > I get:
> > FATAL:  database "Bruce" does not exist
> > 
> > "Bruce" is my user name on WinXP
> > 
> > The help options show the command should work - any ideas?
> 
> Stop using proprietary software ?
> 
> --strk;