On Wed, 23 Feb 2011, Darrell Fuhriman wrote:
> Why make it so hard?
>
> begin;
> SELECT * INTO new_table FROM old_table;
> DROP old_table;
> CREATE old_table ( new definition );
> INSERT INTO old_table SELECT col1,col2,col3,etc. FROM new_table;
> DROP new_table;
> commit;
Darrell,
Because, while I've winnowed the number of columns from 73 to 63, I don't
want to type all 63 column names interactively. :-)
But, I'm learning from all of you and really appreciate it!
Rich