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
