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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to