Ravi, Try specifying the full path to the .sql file. It sounds like its defaulting to a location e.g the pg data folder where your account doesn't have rights to write to.
So for example try "C:/bc_pubs.sql" Leo -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Ravi Sent: Sunday, July 26, 2009 6:53 PM To: postgis Subject: [postgis-users] shp2pgsql Hi, trying to create an SQL for a shape file. shp2pgsql -i -D -s 3005 bc_pubs.shp bcpubs > bc_pubs.sql this issues an error from command prompt Error: 'Access Denied' My Vista user = Ravi PostGIS user = postgres any suggestions pl Ravi See the Web's breaking stories, chosen by people like you. Check out Yahoo! Buzz. http://in.buzz.yahoo.com/ _______________________________________________ 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