Re: [GENERAL] table column reordering

2007-09-24 Thread Gregory Stark
"Josh Trutwin" <[EMAIL PROTECTED]> writes: > A couple things would have saved me lots of time and head scratching: > > Being able to execute COPY TABLE where table name is a view - not > sure why this isn't possible. > > Being able to COPY TABLE with the result of a SELECT command where I > can sp

[GENERAL] table column reordering

2007-09-24 Thread Josh Trutwin
I was following the posts from a month or two ago about reordering columns using syntax similar to MySQL's: ALTER TABLE tbl ALTER COL col1 AFTER/BEFORE col2; I have been working on a new project that adds some functionality to an existing database schema, which caused some tables to expand with n