How to create Temporary table with AS in postgresql?

Question

Create Temporary Table Temp3 ( 
user_id int not null,
) AS query(
select id 
from users
)

I use the above code in postgresql but it says:

ERROR: syntax error at or near ")" LINE 3: ) AS ( ^

****** Error ******

ERROR: syntax error at or near ")" SQL state: 42601 Character: 55

How can I fix it to do the same job? Thx ahead!

See http://stackoverflow.com/questions/15691243/creating-temporary-tables-in-sql — John Powell, May 28 '14 at 21:42
Is it really that hard to read the manual? http://www.postgresql.org/docs/current/static/sql-createtableas.html — a_horse_with_no_name, May 28 '14 at 22:57

klin · Accepted Answer · 2014-05-28T22:35:23.930

0

It is much simpler than your try:

create temporary table Temp3 as
    select id as user_id
    from users;

edited May 28 '14 at 22:35

answered May 28 '14 at 21:38

klin

1 Answers1