Postgresql – CREATE TABLE SYNTAX ERROR USING LIKE –

You need to put the like in to parens like

CREATE TEMP TABLE table1_tmp ( LIKE table1 INCLUDING DEFAULTS ) ;

This is not obvious from the docs if you don’t count parens 1:1