Hi,
I want to make a little correction. The correct syntax should be:
SELECT [all columns except named] into mytemp1 from [$table_name] ;
drop table [$table_name];
SELECT * into [$table_name] from mytemp1;
With regards,
Devrim G�ND�Z
Keith Gray <keith@heart.com.au> wrote in message
news:3B0DFBF9.CEBDC3CC@heart.com.au...
> Bruno Boettcher wrote:
> >
> > Hello!
> >
> > as far as i can tell, i can add columns to a table, but can't remove
> > them later on.....
> >
> > is this true?
>
> My thought would be that somebody must have written an
> automated version of
>
> select [all columns except named] from [named table] into droptemp;
> drop [named table];
> select * from droptemp into [named table];
>
> Would this be available or easily written as a "rule" ??
> Could anyone familiar with the code comment?
>
> --
> Keith Gray
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html