Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

renaming an unnamed column

305 views
Skip to first unread message

Greg Hennessy

unread,
Aug 13, 2012, 5:30:57 PM8/13/12
to
I'm using postgresql 8.1.23 on a redhat 5 machine. I have some tables
that have a schema of:


PS1=# \d tmp_00
Table "public.tmp_00"
Column | Type | Modifiers
-----------+---------+-----------
ra | integer |
dec | integer |
dcol | integer |
drow | integer |
magnitude | integer |
ccdid | integer |
mag_err | integer |
xraw | integer |
yraw | integer |
flags | bigint |
?column? | integer |
fileid | integer |

PS1=#

How do I rename the column named ?column? to be something else?

alter table fails.

PS1=# alter table tmp_00 rename column `?column?` to nest1;
ERROR: syntax error at or near "`?" at character 34
LINE 1: alter table tmp_00 rename column `?column?` to nest1;
^
PS1=#

Jens Henrik Leonhard Jensen

unread,
Aug 14, 2012, 12:49:30 AM8/14/12
to
On 13/08/12 23:30, Greg Hennessy wrote:
>
> How do I rename the column named ?column? to be something else?
>
>
> PS1=# alter table tmp_00 rename column `?column?` to nest1;
> ERROR: syntax error at or near "`?" at character 34
> LINE 1: alter table tmp_00 rename column `?column?` to nest1;
> ^

Quote using ":

PS1=# alter table tmp_00 rename column "?column?" to nest1;

/Jens Henrik

Greg Hennessy

unread,
Aug 15, 2012, 8:59:39 AM8/15/12
to
On 2012-08-14, Jens Henrik Leonhard Jensen <jh...@statsbiblioteket.dk> wrote:
> Quote using ":


Thank you. That worked fine.

0 new messages