Обсуждение: table column with special characters

Hi,

I need to query a table with column name having
special characters ":", "@", "/", for example:
ab:cde12n/5k@90m

When performing a select on this column I get this
error:

 ERROR:  parser: parse error at or near ":"

Any suggestions how to escape these special
characters?

thanks
rk




__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

On Fri, 2 Jul 2004, Rahul k wrote:

> I need to query a table with column name having
> special characters ":", "@", "/", for example:
> ab:cde12n/5k@90m

You'd need to double quote the name on creation and on any usage of the
name (for example in a select list or expression) in SQL statements.