Remove the quotes around echo
echo select count(*) from web_20200619; | "C:\Program
Files\postgresql\11\bin\psql" -d *** -h *** -U ***
or, store your query into a text file and use
psql -f query.sql
Sent from my mobile phone
> Le 19 juin 2020 à 02:00, Adrian Klaver a écrit :
>
> On 6/18/20
There is an alternate solution, which is to launch pgadmin GUI, connect to the
database, tick « save password »
Then psql won’t prompt fir password any more.
Pay however attention to the security concern.
Sent from my mobile phone
> Le 19 juin 2020 à 17:07, Pepe TD Vo a écrit :
>
>
> app
