am Mon, dem 16.10.2006, um 14:56:27 -0400 mailte Harpreet Dhaliwal folgendes: > Hi, > I have a timestamp field in my table and want to set a default value of > current > date/time for it. > What should i enter as its default value? is there any function like now() in > postgres?
Yes, now() ;-) test=# create table foo (id int, ts timestamp default now()); CREATE TABLE test=# insert into foo (id, ts) values (1, default); INSERT 0 1 test=# select * from foo; id | ts ----+--------------------------- 1 | 2006-10-16 21:18:15.75039 (1 row) Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
