Re: Need to run a job in PgAdmin-III - Mailing list pgsql-general

 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