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.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
