On 09/25/2014 03:24 AM, Emanuel Araújo wrote:
Thank's Adrian,
I want really create another CURRENT_DATE called SYSDATE.
postgres=# SELECT CURRENT_DATE ;
date
------------
2014-09-25
(1 row)
I need that:
postgres=# SELECT SYSDATE ;
date
------------
2014-09-25
Because, I am trying SymmetricDS between Oracle and PostgreSQL, in my
case, there are a lot of fields with "DEFAULT trunc(sysdate)". This
situation break when I start the sincronization why the data type there
isn't in PostgreSQL.
Best guess is the answer lies here:
http://www.symmetricds.org/doc/3.6/user-guide/html/config.html#configuration-transforms
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
