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.postgresql.org/docs/8.4/static/sql-createtable.html
LIKE parent_table [ { INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS |
INDEXES } ]
> 2. Do SELECT INTO even if the second table already exists.
INSERT INTO foo ... SELECT
Regards,
Jeff Davis