----- Original Message -----
From: "gomathi raju" <gomathi_raju@usa.net>
> I want to get the system timestamp from postgresql database.
> But I dont have a dual table from where ,I can select it.
> Give me a solution, from which table(system) I can get it.
No need to get it from a system table; it is available as a sort of "global
constant," current_timestamp.
Use it like this:
SELECT CURRENT_TIMESTAMP;
See the book at: http://www.postgresql.org/docs/awbook.html for more
information.
-Mike