Hi Igor, Thanks for the info. I am using double quotes now and getting the result that I needed.
Thank you, Maria On Tue, Jul 29, 2008 at 3:14 PM, Igor Neyman <[EMAIL PROTECTED]> wrote: > Maria, > > Try "" (double quotes: > > select x1 as "IL-a", x2 as "IL-a(p30)" from abc > > should help. > > Igor > > > > ------------------------------ > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *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 >