Hi Julie, If I am understanding correctly, but have you checked out DbLink for postgresql?
http://www.postgresonline.com/journal/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html Can you provide some more context such as what database type/versions? On Thu, Jul 7, 2011 at 11:21 AM, Julie Davenport <[email protected]>wrote: > > What is the fastest way to populate a table with the results of a query? I > have a join query over 2 tables in database A and I need to insert all the > rows found into a table in database B. > > I cannot do it all in one query: > insert into table3 (select ... from table1, table2...); > because the tables are in different databases and postgresql does not allow > inter-db queries (and the cfquery datasource can only point to one database > at a time anyway). > > I'd like to use Coldfusion Query of Query to help but don't see how. I > cannot query from the query results and insert into a table all in the same > cfquery (since a cfquery tag can have EITHER the datasource pointing to > database table is in, OR dbtype=query to do QofQ): > insert into table3 (select * from myQuery); > > As a result, I have to do the query, then loop through the query results, > and each time through the loop, I insert a row of the results into the > table. This is very slow! Is there a faster way with CF? > > Thanks! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346134 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
