Create AS question

From: "Bob Powell" <Bob(at)hotchkiss(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Create AS question
Date: 2004-12-07 18:32:48
Message-ID: s1b5b108.004@grpwise.hotchkiss.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone:

If I excute the following:

CREATE table Test_backup as
SELECT * FROM Test_Scores;

it creates my table without the original table's constraints or
triggers.

Is there a way to preserve them in the copy?

Thanks.

Bob Powell
Database Administrator

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-12-07 18:35:03 Re: Fwd: 8.0 vs. 7.4 benchmarks
Previous Message Guy Rouillier 2004-12-07 18:20:22 Re: Performance tuning on RedHat Enterprise Linux 3