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
- Re: [GENERAL] Foreign Keys Jose' Soares Da Silva
- [GENERAL] foreign keys Gemeinschaft Studienarbeit Datenbanken
- [GENERAL] foreign keys Lothar Behrens
- [GENERAL] Foreign Keys Simon Drabble
- [GENERAL] foreign keys Radoslaw Stachowiak
- Re: [GENERAL] foreign keys Bruce Momjian
- Re: [GENERAL] foreign keys Radoslaw Stachowiak
- Re: [GENERAL] foreign ... Bruce Momjian
- Re: [GENERAL] foreign ... Stephan Szabo
- Re: [GENERAL] fore... Radoslaw Stachowiak
- [GENERAL] vectro
- [GENERAL] Morten W. Petersen
- Re: [GENERAL] Vince Vielhaber
- Re: [GENERAL] Morten W. Petersen
- Re: [GENE... Morten W. Petersen
- Re: [GENE... Tom Lane
- [GENERAL] Foreign Keys <No Name>
- Re: [GENERAL] Foreign Keys Adam Haberlach
- [GENERAL] Re: Foreign Keys Mitch Vincent
- Re: [GENERAL] Foreign keys Stephan Szabo
- Re: [GENERAL] Foreign Keys Bruce Momjian