CREATE TABLES AS looses constraints

From: Tiaan Wessels <tiaan(at)netsys(dot)co(dot)za>
To: pgsql-sql(at)postgresql(dot)org
Subject: CREATE TABLES AS looses constraints
Date: 2003-05-29 16:35:34
Message-ID: 20030529163556.7EBDE925D04@developer.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Olbersen 2003-05-29 17:00:32 Rows UPDATEd?
Previous Message Brian Knox 2003-05-29 16:11:42 "record" datatype - plpgsql