Alvaro Herrera wrote: ... > > You can use CREATE TABLE LIKE, which copies the definition but does not > set the inheritance. > Well, sort of. Unless I'm using it incorrectly it only copies the basic column definitions and, as optionally specified, defaults and some of the constraints. Primary key constraints are lost as CREATE TABLE newtable (LIKE oldtable) does not create any indexes including those necessary for the primary key. I don't know how foreign-key constraints are handled as I haven't used this form of CREATE TABLE where foreign keys are involved. Cheers, Steve ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
