X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id EC1DA475F1C
	for <pgsql-sql@postgresql.org>; Tue, 15 Apr 2003 05:50:11 -0400 (EDT)
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by postgresql.org (Postfix) with ESMTP id 4BAF4475D3B
	for <pgsql-sql@postgresql.org>; Tue, 15 Apr 2003 05:50:11 -0400 (EDT)
Received: from klaster.net (localhost [127.0.0.1])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id 250B72B3CF; Tue, 15 Apr 2003 11:50:12 +0200 (CEST)
From: "jasiek" <jasiek@klaster.net>
To: Rado Petrik <r.p@szm.sk>, pgsql-sql@postgresql.org
Subject: Re: atomatic insert date and time
Date: Tue, 15 Apr 2003 11:50:12 +0200
Message-Id: <20030415094834.M11527@klaster.net>
In-Reply-To: <1050397128.992.41.camel@caj>
References: <1050397128.992.41.camel@caj>
X-Mailer: Open WebMail 2.00 20030404
X-OriginatingIP: 217.96.97.171 (jasiek@klaster.net)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2
X-Spam-Status: No, hits=-15.5 required=5.0 tests=BAYES_10,IN_REP_TO,REFERENCES
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/222
X-Sequence-Number: 12923

On 15 Apr 2003 10:58:48 +0200, Rado Petrik wrote
> 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
Use now() when defining your table.
It would be something like this:
create table some_table(
...
dt_created timestamptz default now()
);

Remember, that now() is a transaction time, so inside one transaction all 
rows would have the same time.

Regards,
Tomasz Myrta