timestamp field

[Ashok Chauhan]

hi
there is any command to see the timestamp of any record that is stored
in a table already.
Except that add a field of timestamp type in that table.
plz help me.




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Andrei Bintintan]

Hi,

I don't know if there is such a command, with my experience I think there
isn't such one.
Do you need it for all the tables?? Put a field like timestamp and put the
default value: now()... it will update automatically, so you don't have to
bother with it.

Best Regards.
Andy.

----- Original Message -----
From: "Ashok Chauhan" <***@kalculate.com>
To: <pgsql-***@postgresql.org>
Sent: Monday, December 08, 2003 3:21 PM
Subject: [ADMIN] timestamp field

Post by Ashok Chauhan
hi
there is any command to see the timestamp of any record that is stored
in a table already.
Except that add a field of timestamp type in that table.
plz help me.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Andrei Bintintan]

I never thought of something like this, but it's a good question.
I will look in the next days to this problem, if I find something I will
post it.

Post on the forum, everyone may be interested.

Best Regards.
Andy.

----- Original Message -----
From: "Ashok Chauhan" <***@kalculate.com>
To: "Andrei Bintintan" <***@ar-sd.net>
Sent: Monday, December 08, 2003 4:01 PM
Subject: Re: [ADMIN] timestamp field

thanks for reply
Yes i want for all the tables.
But the problem is i not change the structure of the tables (means i not
add the timestamp field in all tables)
have any solution without adding the field ?

Post by Andrei Bintintan
Hi,
I don't know if there is such a command, with my experience I think there
isn't such one.
Do you need it for all the tables?? Put a field like timestamp and put the
default value: now()... it will update automatically, so you don't have to
bother with it.
Best Regards.
Andy.
----- Original Message -----
Sent: Monday, December 08, 2003 3:21 PM
Subject: [ADMIN] timestamp field

Post by Ashok Chauhan
hi
there is any command to see the timestamp of any record that is stored
in a table already.
Except that add a field of timestamp type in that table.
plz help me.
---------------------------(end of

broadcast)---------------------------

Post by Andrei Bintintan

Post by Ashok Chauhan
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings