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: F4C27E77F7A33E4CA98C19A9DC6722A2033FAFC3@EXCHANGE.corp.perceptron.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

In response to

Responses

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-2014 The PostgreSQL Global Development Group