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.