[postgis-users] Error using pgsql2shp

[Michael Davison]

Perhaps try using '-d' or '--dbname':

pgsql2shp -f test.shp DWR --dbname dwr_gis

mike

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;
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>