table column with special characters

[Rahul k]

Hi,

I need to query a table with column name having
special characters ":", "@", "/", for example:
ab:cde12n/***@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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Stephan Szabo]

Post by Rahul k
I need to query a table with column name having

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.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster