[GENERAL] Help using SELECT INTO to make schema

2009-07-22 Thread Robert James
I'd like to SELECT INTO one table into another one. However, I'd like to do two things that I don't know how to do using SELECT INTO: 1. Copy over the indexes and constraints of the first table into the second 2. Do SELECT INTO even if the second table already exists. Is there anyway to do eith

Re: [GENERAL] Help using SELECT INTO to make schema

2009-07-22 Thread Jeff Davis
On Wed, 2009-07-22 at 18:15 -0400, Robert James wrote: > I'd like to SELECT INTO one table into another one. However, I'd like > to do two things that I don't know how to do using SELECT INTO: > > 1. Copy over the indexes and constraints of the first table into the > second See: http://www.postg