On Tue, Jan 27, 2009 at 14:31, Michael Bayer <[email protected]> wrote:
>
> there's nothing stopping you from just executing the SQL directly.
> I've never actually heard of CREATE TABLE AS before, but I just
> checked it out and you can certainly generate the SQL programmatically
> from a select, by inspecting each column in the select statement's "c"
> collection. It appears to be part of the SQL standard so is a
> syntax we would accept (it would be appropriate for the 0.6 series
> where we have CreateTable structures available). But SQLA is a
> "toolkit" and the tools are there already to automate this process
> without a pre-made feature.
I recently had to code something like that in a stored procedure
(postgresql database):
create TEMP table temp_boleto_guia as
select .... (huge select);
Does this CreateTable support temporary table syntax ?
[]s
Roger
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
