Re: column names with - and (

Hi Igor,
Thanks for the info.
I am using double quotes now and getting the result that I needed.

Thank you,
Maria

On Tue, Jul 29, 2008 at 3:14 PM, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:

> Maria,
>
> Try "" (double quotes:
>
> select x1 as "IL-a", x2 as "IL-a(p30)" from abc
>
> should help.
>
> Igor
>
>
>
> ------------------------------
> *From:* pgsql-sql-owner(at)postgresql(dot)org [mailto:
> pgsql-sql-owner(at)postgresql(dot)org] *On Behalf Of *maria s
> *Sent:* Tuesday, July 29, 2008 12:07 PM
> *To:* Osvaldo Rosario Kussama; pgsql-sql(at)postgresql(dot)org; Pavel Stehule;
> Ivan Sergio Borgonovo
> *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
>