Re: Copying data from a CSV file into a table dynamically - Mailing list pgsql-general

From pavan95
Subject Re: Copying data from a CSV file into a table dynamically
Date
Msg-id 1534253907682-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Copying data from a CSV file into a table dynamically  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Copying data from a CSV file into a table dynamically
Re: Copying data from a CSV file into a table dynamically
List pgsql-general
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!!

Thanks in Advance

Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


pgsql-general by date:

Previous
From: Don Seiler
Date:
Subject: Re: Vacuum process waiting on BufferPin
Next
From: Ron
Date:
Subject: Re: Copying data from a CSV file into a table dynamically