About create table as select (CTAS)

Question

When we do:

create table big2 as select * from big1;

Are the indexes and constraints also copied over to the new table?

Answer 1

Only NOT NULL constraints are copied. See FAQ.

You can do CREATE TABLE big2 (bigid PRIMARY KEY) AS SELECT * FROM big1 tp create a primary key, but yes, for other indexes you'll want to copy and run the index creation scripts.