Re: [sqlalchemy] MetaData, postgresql, and temporary tables

2010-11-22 Thread Michael Bayer
On Nov 22, 2010, at 12:42 PM, Jon Nelson wrote: > I have an app where I think I'm going to want to use a TEMPORARY TABLE > like this: > > CREATE TEMPORARY TABLE results AS SELECT .; > > and then do two things: > > 1. I need a select count(1) from that table > 2. I need to be able to iterat

[sqlalchemy] MetaData, postgresql, and temporary tables

2010-11-22 Thread Jon Nelson
I have an app where I think I'm going to want to use a TEMPORARY TABLE like this: CREATE TEMPORARY TABLE results AS SELECT .; and then do two things: 1. I need a select count(1) from that table 2. I need to be able to iterate over the rows in that table The reason I am using a TEMPORARY tab