Postgres Pro
Downloads
Home   >   mailing lists

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

From Oliveiros Cristina
Subject Re: column names with - and (
Date
Msg-id 004301c8f198$045791f0$ec5a3d0a@marktestcr.marktest.pt
Whole thread Raw
In response to column names with - and (  ("maria s" <psmg01@gmail.com>)
Responses Re: column names with - and (  ("maria s" <psmg01@gmail.com>)
List pgsql-sql
Tree view
Maria,
 
The minus, open bracket and close bracket are illegal as identifier names
 
 
Best,
Oliveiros
 
----- Original Message -----
From: maria s
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

pgsql-sql by date:

Previous
From: "maria s"
Date:
Subject: column names with - and (
Next
From: "maria s"
Date:
Subject: Re: column names with - and (