Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #399 > unrolled thread

renaming an unnamed column

Back to article view | Back to comp.databases.postgresql

Contents

  renaming an unnamed column Greg Hennessy <greg.hennessy@cox.net> - 2012-08-13 21:30 +0000
    Re: renaming an unnamed column Jens Henrik Leonhard Jensen <jhlj@statsbiblioteket.dk> - 2012-08-14 06:49 +0200
      Re: renaming an unnamed column Greg Hennessy <greg.hennessy@cox.net> - 2012-08-15 12:59 +0000

#399 — renaming an unnamed column

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=# 

[toc] | [next] | [standalone]

#400

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

[toc] | [prev] | [next] | [standalone]

#404

On 2012-08-14, Jens Henrik Leonhard Jensen <jhlj@statsbiblioteket.dk> wrote:
> Quote using ":


Thank you. That worked fine.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.postgresql

csiph-web