Hi James, In MySQL you could use "select last_insert_id()" to get the insert id of table 1 and use that as the fk in table 2. In Postgresql I think it is a bit more complicated. Something like: SELECT CURRVAL(pg_get_serial_sequence('my_tbl_name','id_col_name')); On Wed, Jan 19, 2011 at 2:11 PM, James Nzomo <kazikubwa@gmail.com> wrote:
That's what i usually do but i want to know if there is a more efficient way to set the foreign key on insert
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards Brian Ngure