Create in WITH(CTE) using PostgreSQL

Question

I am trying to create temporary table within WITH using function in PostgreSQL.

Example:

with mm
as
(
     select * from test
)
create table xyz as select * from mm
;

Note: Getting error near create

Answer 1

create table xyz as 

with mm
as
(
     select * from test
)
select * from mm 
where myfield = myvalue
;

Relevant documentation. In documentation, there is no explicit description on how to use create table as together with CTE. However it clearly states it's syntax (simplified):

CREATE TABLE table_name
    AS query

Where query can be (quoting):

A SELECT, TABLE, or VALUES command, or an EXECUTE command that runs a prepared SELECT, TABLE, or VALUES query.

From this it should be pretty much clear why your attempt failed.