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
