Create AS question - Mailing list pgsql-general

From Bob Powell
Subject Create AS question
Date
Msg-id s1b5b108.004@grpwise.hotchkiss.org
Whole thread Raw
Responses Re: Create AS question  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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

pgsql-general by date:

Previous
From: Joachim Zobel
Date:
Subject: Reusable database design
Next
From: Greg Stark
Date:
Subject: Re: When to encrypt