| From: | pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Copying data from a CSV file into a table dynamically |
| Date: | 2018-08-14 13:10:53 |
| Message-ID: | 1534252253597-0.post@n3.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I am well versed with the COPY command for copying the contents of a csv
file into a table. I am used to the below mentioned command:
* COPY postgres_log1 FROM '/tmp/abc/xyz/postgresql-2018-08-14_000000.csv'
WITH csv;*
But in the location "/tmp/abc/xyz/" daily a file(with header
postgresql-2018-08-14_000000.csv) will be generated.
So how can I automate this task instead of manually specifying the file
name, it has to look for the filename with current_date at the time of
copying into table. How can I achieve this?
Any suggestions or modifications are most welcome.
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-08-14 13:20:11 | Re: Copying data from a CSV file into a table dynamically |
| Previous Message | rob stone | 2018-08-14 12:20:44 | Re: Uncaught PHP Exception Doctrine\DBAL\Exception\UniqueConstraintViolationException: "An exception occurred while executing 'UPDATE |