atomatic insert date and time

From: Rado Petrik <r(dot)p(at)szm(dot)sk>
To: pgsql-sql(at)postgresql(dot)org
Subject: atomatic insert date and time
Date: 2003-04-15 08:58:48
Message-ID: 1050397128.992.41.camel@caj
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi ,

I have column type "timestamptz".
I need automatic add date and time when create new row.

example.

id | name | dt_created
---------------------

INSERT INTO table (name) VALUES('test')

id | name | dt_created
-------------------------------
1 test 1980-06-25 11:11-7

thanks. Rado.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jasiek 2003-04-15 09:50:12 Re: atomatic insert date and time
Previous Message Tom Lane 2003-04-15 06:38:34 Re: fast case-insensitive sort