Hi, It seems as if a CREATE TABLES AS does not duplicate the table constraints. How can I enforce this. I need the fastest possible way to make an exact copy of a table. This is to support the administrative mechanism in an app where changes are made to a mirrored copy of a set of tables first and when happy, these are copied to the operational tables. Regards Tiaan
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
