Re: timestamp field

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" <ashok(at)kalculate(dot)com>
To: "Andrei Bintintan" <klodoma(at)ar-sd(dot)net>
Sent: Monday, December 08, 2003 4:01 PM
Subject: Re: [ADMIN] timestamp field

> On Mon, 2003-12-08 at 19:00, Andrei Bintintan wrote:
>
> 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 ?
> > 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" <ashok(at)kalculate(dot)com>
> > To: <pgsql-admin(at)postgresql(dot)org>
> > Sent: Monday, December 08, 2003 3:21 PM
> > Subject: [ADMIN] timestamp field
> >
> >
> > > 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 majordomo(at)postgresql(dot)org)
>