When we do:
create table big2 as select * from big1;
Are the indexes and constraints also copied over to the new table?
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With