On Wed, Dec 14, 2016 at 1:17 PM, Patrick B <patrickbake...@gmail.com> wrote:
> > > 2. To call the function, I have to login to postgres and then run: select > logextract(201612015, 201612015); > How can I do it on cron? because the dates will be different every time. > PostgreSQL already knows what date today is. Why does cron have to tell it? Just do 'select logextract()' and let Postgresql compute the dates for itself. Cheers, Jeff