DB porting questions...

Hi all,

I'm in the final stages of migrating from mysql to postgres and have a few
more questions...

1)
I have a table:
create table a (
t timestamp not null,
...
);

I'm thinking that I can define a.t as not null default=now(). But will this
work? That is, will it update a.t when I modified a given record?

2)
I have another table:
create table b (
id int not null AUTO_INCREMENT,
...
);

To reproduce this behavior, I believe I need to use a sequence. The problem
is that I have a lot of data to import into this table. How do I import the
old data without colliding with the new sequence numbers?

Thanx in advance,
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
jdiehl(at)sandia(dot)gov