Request a Demo
Home   >   mailing lists

column names with - and ( - Mailing list pgsql-sql

From maria s
Subject column names with - and (
Date
Msg-id d9d42a0f0807290906v1a1efabbm1304ddc2ab0f0b9@mail.gmail.com
Whole thread Raw
Responses Re: column names with - and (
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: Re: Query prepared plan
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: column names with - and (