[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

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 specify the