Thread: timestamp field

timestamp field

From
Ashok Chauhan
Date:
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.




Re: timestamp field

From
"Andrei Bintintan"
Date:
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


Re: timestamp field

From
"Andrei Bintintan"
Date:
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)
>