Re: [ADMIN] table column with special characters

2004-07-02 Thread Stephan Szabo
On Fri, 2 Jul 2004, Rahul k wrote: > I need to query a table with column name having > special characters ":", "@", "/", for example: > ab:cde12n/[EMAIL PROTECTED] 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 stat

[ADMIN] table column with special characters

2004-07-02 Thread Rahul k
Hi, I need to query a table with column name having special characters ":", "@", "/", for example: ab:cde12n/[EMAIL PROTECTED] 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