--- operationsengineer1(at)yahoo(dot)com wrote:
> i'm trying to merge two tables together.
> i'm able to do it with...
> select *
> into t_temp_final
> from t_temp_output
> SELECT * FROM t_product
> however, i lost all my primary key values in
> i can't create a pkey now b/c i have 1000 null
> how can i get around this situation?
the current t_product table entries have product_id
values. the temp table doesn't. so i need to add
product_ids wher where product_id IS NULL.
if i knew how to create a serial field (and control
its values to start at a level greater than the
highest t_product product_id value) in an insert into
temp table, i could create product_ids when i create
the insert into temp table and then merge everything
together - complete with product_ids in place.
is this the best way? if so, how can i work in a
serial field when doing an insert into?
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
In response to
pgsql-novice by date
|Next:||From: Richard Broersma Jr||Date: 2006-06-26 20:21:54|
|Subject: Re: Table Merge Successful, Primary Keys Missing|
|Previous:||From: operationsengineer1||Date: 2006-06-26 18:47:23|
|Subject: Table Merge Successful, Primary Keys Missing|