Messages

not sure how I got those 2 in one line I tried so many things.
Here it is again with correct lines:

C:\Program Files\PostgreSQL\8.3\bin>pgsql2shp  -f "C:\washington\hydro\Area.shp"
-u postgres -p postgis nhd_area

**ERROR** invalid option or command parameters

RCSID: $Id: pgsql2shp.c 2762 2008-04-10 14:44:26Z pramsey $ RELEASE: 1.3.3
USAGE: pgsql2shp [<options>] <database> [<schema>.]<table>
       pgsql2shp [<options>] <database> <query>

OPTIONS:
  -f <filename>  Use this option to specify the name of the file
     to create.
  -h <host>  Allows you to specify connection to a database on a
     machine other than the default.
  -p <port>  Allows you to specify a database port other than the default.
  -P <password>  Connect to the database with the specified password.
  -u <user>  Connect to the database as the specified user.
  -g <geometry_column> Specify the geometry column to be exported.
  -b Use a binary cursor.
  -r Raw mode. Do not assume table has been created by
     the loader. This would not unescape attribute names
     and will not skip the 'gid' attribute.
  -k Keep postgresql identifiers case.
  -? Display this help screen.

Ok that worked, I got to the next step no problems but trying to export it to the correct folder as .shp file keeps bringing up a error like:
C:\Program Files\PostgreSQL\8.3\bin>pgsql2shp  -f "C:\washington\hydro\Area.shp"
Waterbody.shp" -u postgres postgis nhd_waterbody

**ERROR** invalid option or command parameters

RCSID: $Id: pgsql2shp.c 2762 2008-04-10 14:44:26Z pramsey $ RELEASE: 1.3.3
USAGE: pgsql2shp [<options>] <database> [<schema>.]<table>
       pgsql2shp [<options>] <database> <query>
and of course it has a help file with the command letters.
I made sure the folders where not open so there would not be a permissions issue and get the same thing. Did I miss a step?
Cheers-Marc

That makes a lot of sense. I will work on today. Thanks for the quick help.
Cheers-Marc

Hi, Forgive me if this is obvious (I did search the forum for a answer first) but I am trying to make a top mapo of just the Olympic Peninsula in my first attempt at this.
I think I have everything I need. When attempting to work with the NHD files in the command line I get this:

C:\Program Files\PostgreSQL\8.3\bin>shp2pgsql "C:\My Documents\washington\hydro\
NHDArea.shp" NHD_Area > nhd_area.sql
C:\My Documents\washington\hydro\NHDArea.shp: shape (.shp) or index files (.shx)
can not be opened, will just import attribute data.
C:\My Documents\washington\hydro\NHDArea.shp: dbf file (.dbf) can not be opened.
C:\Program Files\PostgreSQL\8.3\bin>
As one cane see the path appears correct because of the initial action it takes but I can not get any where else. Does any one see the mistake. Thank you in advance for any help.
I have fw tool installed, when I drag the shape files to the merge .bat files the black command screen comes up but disappears so fast I can not read what it does.
Maybe it there?
Cheers-Marc