pgcsv is not recognized as an internal or external command

[Ak784]

Hello,

am new to pgcsv and command line thingy.

I have a csv and would like to generate a table in my postgres db using this csv.

So, I did pip install pgcsv in my anaconda prompt (which was successful)

Later, naviagated to Jupyter notebook and typed the below command

localhost = 'xxx.x.xxx.xx'
database = 'testdv'
!pgcsv --db postgresql://localhost/database new_table Test_data.csv`

But I got the below warning but jupter cell execution is complete

'pgcsv' is not recognized as an internal or external command,
operable program or batch file.