On Sat, 5 Aug 2000, Bruce Momjian wrote:
> > Not to mentions fact that in a few places in docs it's shown as a method
> > for copying table "SELECT... INTO" which does not "take" keys with it
> > leading to database knwoledge loss.
>
> That is a good point. SELECT INTO doesn't support constraints.
> Unfortunately, I don't really know a way around that. The only solution
> is CREATE TABLE and then INSERT INTO ... SELECT.
Argh, that's annoying.
Is there a way to CREATE TABLE, getting the schema from another table? :o
Ian