Re: column names with - and (

You can enclose the names in quotes, then the characters are allowed

 

Sorry to mislead you :p

 

Best,

Oliveiros

 

 

----- Original Message -----

From: Oliveiros Cristina

To: maria s ; Osvaldo Rosario Kussama ; pgsql-sql@postgresql.org ; Pavel Stehule ; Ivan Sergio Borgonovo

Sent: Tuesday, July 29, 2008 5:27 PM

Subject: Re: [SQL] column names with - and (

Maria,

 

The minus, open bracket and close bracket are illegal as identifier names

 

http://www.postgresql.org/docs/8.3/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

 

Best,

Oliveiros

 

----- Original Message -----

From: maria s

To: Osvaldo Rosario Kussama ; pgsql-sql@postgresql.org ; Pavel Stehule ; Ivan Sergio Borgonovo

Sent: Tuesday, July 29, 2008 5:06 PM

Subject: [SQL] column names with - and (

Hi All,
When I am fetching the data from a table,
I am giving the column names with - and ( and ) like IL-a, IL-a(p30) etc..

select x1 as IL-a, x2 as IL-a(p30) from abc

But I am getting

ERROR:  syntax error at or near "-" and also t "(" , ")"

Can anyone help me to fix this?

Thank you,
Maria