Received: from mail.gkg-com.com (root@mail.gkg-com.com [206.28.9.3]) by hub.org (8.8.8/8.7.5) with ESMTP id MAA19205 for ; Sat, 11 Jul 1998 12:16:04 -0400 (EDT) Received: from gkg.net (1Cust44.tnt2.plano.tx.da.uu.net [208.252.48.44]) by mail.gkg-com.com (8.8.5/8.8.5) with ESMTP id LAA24267; Sat, 11 Jul 1998 11:11:08 -0500 Sender: mschout@mail.gkg-com.com Message-ID: <35A78FAF.8D6E54AF@gkg.net> Date: Sat, 11 Jul 1998 16:15:43 +0000 From: Michael J Schout X-Mailer: Mozilla 4.04 [en] (X11; I; Linux 2.1.108 i486) MIME-Version: 1.0 To: Johann Spies CC: Postgres-poslys Subject: Re: [SQL] The date of an entry? References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Johann Spies wrote: > > Is there a system field that can enable me to determine when an entry into > the database was made? I see a reference to 'abstime'. How can that be > accessed? Abstime is a column type, just like datetime, date, or even int for that matter. Once upon a time, there used to be "time travel" in postgreSQL so every row had a tmin,tmax field in it that would show the last time the row was updated, but they are no longer available as time travel was removed in the interest of efficiency. You can get the same effect by creating your own timestamp column though: create table foo (ts timestamp default now(), f1 int); insert into foo (f1) values (12345); select * from foo; ts | f1 ----------------------+----- 1998-07-11 11:10:37-05|12345 (1 row) Regards, Mike