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

From Tom Lane
Subject Re: CREATE TABLE AS ... EXECUTE
Date
Msg-id 1555.1056731814@sss.pgh.pa.us
Whole thread Raw
In response to CREATE TABLE AS ... EXECUTE  (Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>)
List pgsql-hackers
Alvaro Herrera Munoz <alvherre@dcc.uchile.cl> 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.

IIRC there is an EXECUTE INTO.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera Munoz
Date:
Subject: CREATE TABLE AS ... EXECUTE
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: persistant psql feature suggestion