Knowledge Base

How to ensure full index data trigger copy in PostgreSQL table

You can edit a table on PostgreSQL 9 with data, index, trigger, function, etc. You can use the example below to copy it completely with .


CREATE TABLE location_cities_yeni (LIKE location_cities INCLUDING ALL);
INSERT INTO location_cities_new SELECT * FROM location_cities;



You can use the example below to copy only the indexes.



CREATE TABLE location_cities_new (LIKE location_cities INCLUDING INDEXES);

INSERT INTO location_cities_new SELECT * FROM location_cities;