Create a table with all the columns of inner join of two other tables without copying data
CREATE TABLE your_table AS your_select WITH NO DATA;


https://www.postgresql.org/docs/current/static/sql-createtableas.html