Re: CREATE TABLE AS ... EXECUTE

Alvaro Herrera Munoz writes:

> Is there a way to create a table from a prepared statement? CREATE TABLE AS
> explicitly says you have to use a SELECT statement, and the SELECT INTO
> syntax doesn't seem to allow the use of a prepared statement either. I
> don't see a way to use the prepared statement as a function nor as a "table"
> (SELECT ... FROM EXECUTE)

There's EXECUTE INTO, but when I find time I will change it to CREATE
TABLE AS ... EXECUTE, because we don't really like SELECT INTO, so EXECUTE
INTO doesn't seem the right solution.

--
Peter Eisentraut peter_e(at)gmx(dot)net