From: | Rahul Ranjan <rahul(dot)sdabahar(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Fwd: postgres join query. |
Date: | 2013-11-19 09:10:08 |
Message-ID: | CABStvC13U=HamGVN9ucdJRL32NYaMEeKUTpZQpCuRKjn02t=Ag@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
I am using join query as below.
java code
=================
sqlQuery="insert into locations_graphic_map_ksk(chain,
screen,template,location,language,graphic_up_filename,graphic_up,graphic_up_descr,graphic_dn_filename,graphic_dn,graphic_dn_descr)"
+ " select t1.chain, t1.screen, t1.template,
t1.location, t1.language, t1.graphic_up_filename, t2.graphic,
t2.graphic_descr, t1.graphic_dn_filename, t3.graphic, t3.graphic_descr "
+ "from locations_graphic_map_ksk_tmp as t1,
loc_graphic_map_ksk_up as t2, loc_graphic_map_ksk_dn as t3 where
t1.graphic_up_filename=t2.graphic_filename and
t1.graphic_dn_filename=t3.graphic_filename";
st=conn.createStatement();
st.executeUpdate(sqlQuery);
I have one doubt that, are all results get loaded to main memory from join
then it does insertion
or it retrieves few records and do insertion and so on?
Please help.
Thanks,
rahul
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2013-11-19 11:51:28 | Re: Fwd: postgres join query. |
Previous Message | dmp | 2013-11-18 18:41:46 | Re: preparedStatement, Batch, DEFAULT, getGeneratedKeys() |