Mandag 24. september 2012 11.06.32 skrev pavithra :
> I have a scheduled a sql query as "select sysdate from dual" and i have
> given as "Data Export".
That's an Oraclism. Have you actually tested the query in psql?
postgres=> select sysdate from dual;
ERROR: relation "dual" does not exist
LINE 1: select sysdate from dual;
^
postgres=>
Maybe this is what you want?
postgres=> select current_date;
date
------------
2012-09-24
(1 row)
postgres=>
regards, Leif