CREATE TABLES AS looses constraints - Mailing list pgsql-sql

From Tiaan Wessels
Subject CREATE TABLES AS looses constraints
Date
Msg-id 20030529163556.7EBDE925D04@developer.postgresql.org
Whole thread Raw
Responses Re: CREATE TABLES AS looses constraints
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Brian Knox
Date:
Subject: "record" datatype - plpgsql
Next
From: "David Olbersen"
Date:
Subject: Rows UPDATEd?