Naoya Anzai <anzai-naoya@xxxxxxxxxxxxxxxxx> writes: > Accroding to http://www.postgresql.org/docs/9.1/interactive/sql-createtableas.html , > "CREATE TABLE table_name AS EXECUTE name WITH DATA" seems a right syntax, > but,this statement becomes a SYNTAX ERROR. Hmm ... it looks like WITH [NO] DATA is actually only implemented for the query = SelectStmt case, not the query = ExecuteStmt case. We need a less klugy implementation to support EXECUTE :-( regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general