On 08/14/2018 08:38 AM, pavan95 wrote:
Hi Adrian, I tried to use *"COPY postgres_log1 FROM '/tmp/abc/xyz/postgresql-`date --date="0 days ago" +%Y-%m-%d`_*.csv' WITH csv;"* But it resulted in an error. How to issue such that it is understandable by psql? And I am completely unaware of python & psycopg2. Anything which suits my requirement is enough!!ostgresql-archive.org/PostgreSQL-general-f1843780.html
Why not: cat /tmp/abc/xyz/postgresql-`date --date="0 days ago"+%Y-%m-%d`_*.csv' | \ psql YOURDB -c "COPY postgres_log1 FROM STDIN WITH csv;" -- Angular momentum makes the world go 'round.
