Re: [GENERAL] Change table structure.

AFAIK, you can add and and rename columns no problem:

functions=> \h alter table
Command: alter table
Description: add/rename attributes, rename tables
Syntax:
ALTER TABLE class_name [*] ADD COLUMN attr type
ALTER TABLE class_name [*] RENAME [COLUMN] attr1 TO attr2
ALTER TABLE class_name1 RENAME TO class_name2

But you can't drop a column without a DROP and CREATE again.

On Thu, 23 Sep 1999, Michal A. Kowalski wrote:

> Hi,
>
> is there any way to change table structure without doing DROP and CREATE
> again?
>
> Regards,
> MAK.
> ___________________________________________________________________________
> -- Michal A. Kowalski -- http://www.minfo.com.pl -- mak(at)minfo(dot)com(dot)pl --
>
> ************
>

Stuart C. G. Rison
Department of Biochemistry and Molecular Biology
6th floor, Darwin Building, University College London (UCL)
Gower Street, London, WC1E 6BT, United Kingdom
Tel. 0207 504 2303, Fax. 0207 380 7033
e-mail: rison(at)biochem(dot)ucl(dot)ac(dot)uk