Renaming a column starting with '?column?'

Question

I want to rename the column in Postgresql database. The column name i am having is :

id varchar ?column? text name varchar

I have tried using the following command:

alter table <table_name> rename column '?column?' to age;

But i am getting error. Please help me in renaming the column without dropping or recreating the table.

"but I am getting error". What error? show the exact text of the error message in questions about errors, as well as your PostgreSQL version. In this case we can guess what's going on pretty easily, but that won't always be the case and you'll get a better response from people if you provide all the details. — Craig Ringer
– Craig Ringer, Commented Mar 19, 2013 at 11:20

Clodoaldo Neto · Accepted Answer · 2013-03-19 11:20:33Z

4

Use double quotes for identifiers:

alter table <table_name> rename column "?column?" to age;

answered Mar 19, 2013 at 11:20

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Heh, within a second of each other. Removing my answer.