Re: Need to run a job in PgAdmin-III

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need to run a job in PgAdmin-III
Date: 2012-09-24 09:16:35
Message-ID: 201209241116.35675.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pavithra 2012-09-24 09:22:57 Re: Need to run a job in PgAdmin-III
Previous Message pavithra 2012-09-24 09:06:32 Re: Need to run a job in PgAdmin-III