Thank you so much Ron. You saved my efforts after a slight modification of
quotes of the command you said, it started working fine.
The modified command is as below:
cat /tmp/xyz/abc/postgresql-`date --date="0 days ago" +%Y-%m-%d`_*.csv |
psql -U aaa -d mydb -c "COPY postgres_log1 FROM STDIN WITH csv;"
Team,
Thank you so much for your valuable time spent on this!!
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html