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@kalculate.com>
To: "Andrei Bintintan" <klodoma@ar-sd.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@kalculate.com>
> > To: <pgsql-admin@postgresql.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@postgresql.org)
>