insert a SYSTIMESTAMP value in postgres - Mailing list pgsql-general

From Leon Match
Subject insert a SYSTIMESTAMP value in postgres
Date
Msg-id 003d01cc2f80$cbfb86c0$63f29440$@match@convergia.net
Whole thread Raw
Responses Re: insert a SYSTIMESTAMP value in postgres
Re: insert a SYSTIMESTAMP value in postgres
Re: insert a SYSTIMESTAMP value in postgres
List pgsql-general

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?

 

Thank you,

Leon

leon.match@convergia.net

 

 

pgsql-general by date:

Previous
From: Raghavendra
Date:
Subject: Re: how to find a tablespace for the table?
Next
From: Raghavendra
Date:
Subject: Re: how to find a tablespace for the table?