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:
rob stone Date: Subject:
Re: Uncaught PHP ExceptionDoctrine\DBAL\Exception\UniqueConstraintViolationException: "An exceptionoccurred while executing 'UPDATE