Re: column names with - and (
| От | Igor Neyman |
|---|---|
| Тема | Re: column names with - and ( |
| Дата | |
| Msg-id | F4C27E77F7A33E4CA98C19A9DC6722A2033FAFC3@EXCHANGE.corp.perceptron.com обсуждение исходный текст |
| Ответ на | column names with - and ( ("maria s" <psmg01@gmail.com>) |
| Ответы |
Re: column names with - and (
|
| Список | 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@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of maria s
Sent: Tuesday, July 29, 2008 12:07 PM
To: Osvaldo Rosario Kussama; pgsql-sql@postgresql.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
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 по дате отправления: