Skip site navigation (1) Skip section navigation (2)

Re: column names with - and (

From: "Igor Neyman" <ineyman(at)perceptron(dot)com>
To: "maria s" <psmg01(at)gmail(dot)com>,"Osvaldo Rosario Kussama" <osvaldo(dot)kussama(at)gmail(dot)com>,<pgsql-sql(at)postgresql(dot)org>,"Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>,"Ivan Sergio Borgonovo" <mail(at)webthatworks(dot)it>
Subject: Re: column names with - and (
Date: 2008-07-29 19:14:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Try "" (double quotes:
select x1 as "IL-a", x2 as "IL-a(p30)" from abc
should help.



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)

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,

In response to


pgsql-sql by date

Next:From: Richard HuxtonDate: 2008-07-29 21:29:50
Subject: Re: Identifying which column matches a full text search
Previous:From: Ryan WallaceDate: 2008-07-29 18:31:48
Subject: Identifying which column matches a full text search

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group