CREATE TABLE mytable (
id serial not null primary key,
myvalue varchar(50),
create_dt timestamp not null default now()
);
INSERT INTO mytable (myvalue) VALUES ('When was this record inserted ?');
SELECT * FROM mytable;
"Si" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I have added a field to one of my PostgreSQL tables in the "Timestamp"
>datatype, but when I add a row to that table I don't get the date and time
>inserted into that column? Do I need to put a default value into the column
>too?
>
---------------------------(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
