increment the primary key value without using sequences - Mailing list pgsql-sql

Hi all,

 

I would like to know if its possible to increment the primary key field value of stocks table without using sequences by getting the next value of the pk field from the sequnce table ?

 

insert into stocks (prim_id, date,time, code, price, volume) (select ..... from temp_stocks)

 

prim_id               101

 

stocks table (prim_id, date, time, code, price, volume)

 

temp_stocks table (date, time, code, price, volume)

 

If it can be done, can you please explain me with an example.

 

Thanks a lot in advance.