Error:: 'more' is not recognized as an internal or external command

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • crs27
    New Member
    • Jul 2007
    • 40

    Error:: 'more' is not recognized as an internal or external command

    Hai,
    can anyone tel me what dose this error mean.
    'more' is not recognized as an internal or external command,
    operable program or batch file.
  • michaelb
    Recognized Expert Contributor
    • Nov 2006
    • 534

    #2
    Where and how are you trying to execute the "more" command?
    You don't give enough details to answer the question you posted.

    Comment

    • crs27
      New Member
      • Jul 2007
      • 40

      #3
      Hai,
      find the below...

      C:\Program Files\PostgreSQ L\8.2\bin>psql testDB xyz
      Password for user xyz:
      Welcome to psql 8.2.4, the PostgreSQL interactive terminal.

      Type: \copyright for distribution terms
      \h for help with SQL commands
      \? for help with psql commands
      \g or terminate with semicolon to execute query
      \q to quit

      Warning: Console code page (437) differs from Windows code page (1252)
      8-bit characters may not work correctly. See psql reference
      page "Notes for Windows users" for details.

      testDB=> select * from test;
      'more' is not recognized as an internal or external command,
      operable program or batch file.
      testDB=>

      I unable to resolve this,Im very new to PostgreSQL.
      Kindly revert back.

      Thank you

      Comment

      • crs27
        New Member
        • Jul 2007
        • 40

        #4
        Hai,

        one more thing is,i have instaled PostgreSQl directly on Windows.From postgresql.com ,from FTP mirrors.
        But i have doubt is the installation some where wrong,as i have come across the forums that PostgreSQL has to be installed through Cygwin.Im confused.
        Right now im able to create DB,tables and import data through PGAdmin.
        am I wrong anywere,im confused.

        Comment

        • michaelb
          Recognized Expert Contributor
          • Nov 2006
          • 534

          #5
          Let's try to gather some information:

          Open the DOS window and at the prompt type this command:
          more abc
          Hit the Enter key. What happens?

          What version of Windows you are currently using?
          Was it a fresh install, or did you upgrade from some previous version?

          Comment

          • crs27
            New Member
            • Jul 2007
            • 40

            #6
            Originally posted by michaelb
            Let's try to gather some information:

            Open the DOS window and at the prompt type this command:
            more abc
            Hit the Enter key. What happens?

            What version of Windows you are currently using?
            Was it a fresh install, or did you upgrade from some previous version?
            Yup,this is wht i get..
            Im using Windows XP

            C:\Program Files\PostgreSQ L\8.2\bin>more
            'more' is not recognized as an internal or external command,
            operable program or batch file.

            C:\Program Files\PostgreSQ L\8.2\bin>psql testDB sindhu
            Password for user sindhu:
            Welcome to psql 8.2.4, the PostgreSQL interactive terminal.

            Type: \copyright for distribution terms
            \h for help with SQL commands
            \? for help with psql commands
            \g or terminate with semicolon to execute query
            \q to quit

            Warning: Console code page (437) differs from Windows code page (1252)
            8-bit characters may not work correctly. See psql reference
            page "Notes for Windows users" for details.

            testDB=> \h;
            'more' is not recognized as an internal or external command,
            operable program or batch file.

            Comment

            • michaelb
              Recognized Expert Contributor
              • Nov 2006
              • 534

              #7
              Typically you should have the more command (file more.com) in your Windows\system3 2 directory.
              If you don't have it - install it. If it's there make sure that path C:\WINDOWS\syst em32 (or whatever the path is in your computer) is in the PATH variable.
              You can take a quick look at your path settings using the set command at the DOS prompt.

              Code:
              C:\>set path
              Path=C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\SecureCRT3.0;C:\Program Files\PostgreSQL\8.2\bin

              Comment

              • crs27
                New Member
                • Jul 2007
                • 40

                #8
                Originally posted by michaelb
                Typically you should have the more command (file more.com) in your Windows\system3 2 directory.
                If you don't have it - install it. If it's there make sure that path C:\WINDOWS\syst em32 (or whatever the path is in your computer) is in the PATH variable.
                You can take a quick look at your path settings using the set command at the DOS prompt.

                Code:
                C:\>set path
                Path=C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\SecureCRT3.0;C:\Program Files\PostgreSQL\8.2\bin

                Thanks a lotttt michaelb..
                Its working fine..

                Kindly look into my other error too..
                org.postgresql. util.PSQLExcept ion: ERROR: relation "gistl_new_requ est" does not exist
                Even though i have the table by name "gistl_new_requ est",im getting this error.
                Plz michaelb look into it..

                Thank you once again..

                Comment

                • michaelb
                  Recognized Expert Contributor
                  • Nov 2006
                  • 534

                  #9
                  You're welcome.

                  The other problem you mentioned is being discussed here

                  Comment

                  Working...