El 20/06/2011 14:33, "Leon Match" <leon.ma...@convergia.net> escribió: > > Hello, > > > > I am trying to re-create few objects from oracle into postgres. > > > > I have a problem inserting a timestamp value into the table: > > > > insert into request_queue (request_id, received_time > > ) > > values (new.request_id, SYSTIMESTAMP > > ); > > > > How can I insert a dynamic timestamp value in postgress, please? >
Maybe this document can help you http://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion -- Jaime Casanova www.2ndQuadrant.com