psql create table like table including all with no data code example Example: postgresql create table with index CREATE INDEX index_name ON table_name (column_name);