#704 added support for the CREATE TABLE x AS TABLE y by adding basic support for the TABLE command within the context of a CREATE statement. However, as noted in the Postgres docs:
"It can be used as a top-level command or as a space-saving syntax variant in parts of complex queries. Only the WITH, UNION, INTERSECT, EXCEPT, ORDER BY, LIMIT, OFFSET, FETCH and FOR locking clauses can be used with TABLE; the WHERE clause and any form of aggregation cannot be used."
These other cases have yet to be investigated.
#704 added support for the
CREATE TABLE x AS TABLE yby adding basic support for theTABLEcommand within the context of aCREATEstatement. However, as noted in the Postgres docs:"It can be used as a top-level command or as a space-saving syntax variant in parts of complex queries. Only the WITH, UNION, INTERSECT, EXCEPT, ORDER BY, LIMIT, OFFSET, FETCH and FOR locking clauses can be used with TABLE; the WHERE clause and any form of aggregation cannot be used."
These other cases have yet to be investigated.