Hello there,

i have an interface which allows user to update column & data.

how can i rename a column with sql?

if i'm not mistaken, ALTER TABLE table_name RENAME COLUMN old_col_name to new_col_name is not being supported.

is there a COPY statement? if so, how can i go about using it to rename a column name.

i am also trying on INSERT INTO in conjunction with a SELECT statement but unsuccessful so far.

Any ideas?

Thank You

Astro