How to call vsql from cygwin under windows?

usao

Im looking for a way to create scripts and schedule jobs from my PC to Vertica running on a Linux server.
I installed the vsql client on my PC. When I try to run the vsql client, it prompts me for a password. However, it just echos the password to the screen as I type then hangs after I hit enter. If I put the "-w" option with the password on the command line, then vsql just hangs.
In both cases, I never get a SQL prompt.

Shayon_Sanyal

Hi, can you check if you have added the vsql executable to the Windows PATH environment variable? After you have made the change to your PATH environment variable, start a command window and type vsql -? at the command prompt to start vsql.

Shayon_Sanyal

Also, once you have added the vsql executable to the Windows PATH environment variable, make sure your cygwin.bat file does not include the "tty" flag. Refer this link: https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/ConnectingToVertica/vsql/vsqlNotesForWindowsUsers.htm?TocPath=Connecting%20to%20Vertica|Client%20Libraries|Client%20Drivers|Components%20of%20the%20Client%20Drivers%20and%20Tools%20on%20Windows|The%20vsql%20Client%20for%20Windows|_____1

Jim_Knicely

See if the post here helps...

http://vertica-forums.com/viewtopic.php?f=7&t=2813