| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-07-29 21:29:50 | Re: Identifying which column matches a full text search |
| Previous Message | Ryan Wallace | 2008-07-29 18:31:48 | Identifying which column matches a full text search |