Postgres "Like" Keyword

Question

I am trying to create a temporary table in postgres by copying the column names and types from an existing table.

CREATE TEMPORARY TABLE temporary_table LIKE grades;

Typing the query into Postgre, it tells me about an error in LIKE. Is "Like" keyword not usable in Postgre or am I doing something wrong?

Jimmy Stenke · Accepted Answer · 2018-05-31 07:21:53Z

4

You need to wrap the like statement in parentheses:

CREATE TEMPORARY TABLE temporary_table (LIKE grades);

If you want defaults or indexes included as well, you need to add that explicitly

CREATE TEMPORARY TABLE temporary_table 
    (LIKE grades INCLUDING INDEXES INCLUDING DEFAULTS);

answered May 31, 2018 at 7:21

Jimmy Stenke

11.3k2 gold badges27 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1