Re: CREATE TABLE AS ... EXECUTE - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: CREATE TABLE AS ... EXECUTE
Date
Msg-id Pine.LNX.4.44.0306272156090.5890-100000@peter.localdomain
Whole thread Raw
In response to CREATE TABLE AS ... EXECUTE  (Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>)
List pgsql-hackers
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@gmx.net



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Possible mistake in new array syntax
Next
From: Peter Eisentraut
Date:
Subject: Re: 7.2 to 7.4 upgrade issues